Problem with format function in excel VBa
 

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

Problem with format function in excel VBa
 

Go into ToolsReferences 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)

"Camper Joe" wrote in message
...
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