Hi,

I am facing a peculiar problem. I using the following function in V
for finding a date in excel.

Selection.Find(What:=strCurrentDate, After:=ActiveCell
LookIn:=xlValues, LookAt:=xlPart, SearchOrder:=xlByColumns
SearchDirection:=xlNext, MatchCase:=False).Activate

The values will be passed to "strCurrentDate" dynamically.

When I pass values like "20-Jun-04" or "29-Jun-04" the function work
perfect without any errors, but when I pass values like
"01-Jul-04" or "02-Jul-04" then I get error as "Run time error 91
Object variable or block variable not set " .

I feel it has got something to do with the starting zero in the dat
value.

Could any of you help me out with a solution to over come thi
problem.

Thanks in advance

Regards
Anan

--
Message posted from http://www.ExcelForum.com