Thread: Problem with format function in excel VBa
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Camper Joe Camper Joe is offline
external usenet poster
  
Posts: 7
Default 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

Reply With QuoteReply With Quote