| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
search value not formula with .Find
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
search value not formula with .Find
("01-02-04")
will be interpreted mm-dd-yy in VBA. convert to a dateserial DateSerial(2004,2,1) -- Regards, Tom Ogilvy Sunil Patel wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search / find Formula | Excel Worksheet Functions | |||
| IF with Search/Find??? | Excel Worksheet Functions | |||
| Help with a formula for concatenate and search/find with 3 columns | Excel Worksheet Functions | |||
| Can Search find 2 or more "/"? | Excel Discussion (Misc queries) | |||
| Search and find | Excel Programming | |||
Linear Mode
