Problem with format function in excel VBa

C

Camper Joe

I have a statement that goes like this:

If Not Format(Sheets("Filter").Range("F99"), "000.000") =
Format(Sheets("List").Cells(FoundAddress1, 2), "000.000") And _
INDEX333 = Sheets("list").Cells(FoundAddress1, 43) Then


It works on some excel 2003's and doesn't on otre 2003's. I get a reference
library
error.

Any ideas? Can I use another function instead of Format?

Thanks
 
B

Bob Phillips

Go into Tools>References in the VBIDE. If you see any items with MISSING
beside them, uncheck it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top