Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Help!
I'm sure someone has had this problem before. Column C is a column of dates, and is formatted as "14-Mar-98". Some of the cells in column C contain, in integer form, 0 : and are therefore returning "00/01/1900" in the above format. Therefore why does the below throw an error! The below code was the result of using the macro recorder. Columns("C:C").Select Selection.Find(What:="00/01/1900", After:=ActiveCell, _ LookIn:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, _ SearchDirection:=xlNext, MatchCase:=False).Activate Any help greatly appreciated Jason |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find Method problem in Excel VBA.... | Excel Worksheet Functions | |||
Using variables to make a date and using find method to find that. | Excel Programming | |||
Problem with find method | Excel Programming | |||
range.find method called into a VBA function (problem) | Excel Programming | |||
? Find method | Excel Programming |