search value not formula with .Find

  • Thread starter Thread starter Sunil Patel
  • Start date Start date
S

Sunil Patel

Hi , i am using

Set CK = Range("B5:B11").Find("01-02-04")

where B5=a date e.g 31-01-04
B6="B5+1" e.g 01-02-04 * (cant find this cell)
B7+"B5+2" etc

B5 to B11 are date format "dd-mm-yy"

Thanks Sunil
 
("01-02-04")
will be interpreted mm-dd-yy in VBA. convert to a dateserial

DateSerial(2004,2,1)
 
Back
Top