Why doesn't this work?
 

The data type for strStartDt was originally string, and I changed it to Date.
IT worked.

Thanks.

Kirk

"sebastienm" wrote:

Hi
-Is strStartDt defined as a String or a Date
-What a
msgbox strStartDt
returns (what format)
Not where/how the variable get assigned but there might be a problem of
format, in which case you would need to do something like:
strStartDt = Format ( strStartDt_or_a_date, "d-mmm-yyyy")
- also you do a
LookIn:=xlFormulas
Not a xlValues instead?
-then try
Dim Rg as range
Set rg=Selection.Find(What:=strStartDt, After:=ActiveCell,
LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False)
If not rg is nothing then rg.Activate

Regards,
Sebastien

"Kirk" wrote:

I have the following:

Selection.Find(What:=strStartDt, After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate

Basically what I am trying to do is to search for a value (strStartDt) on a
sheet. This doesn't work, but if I hard code strStartDt to a value (i.e.
1-Feb-04), it works find and dandy. I used this same code in a ADP file and
figure it should work in Excel as well.

I get the following error:
Run-time error '91':
Object variable or With block variable not set

Any ideas as to why this is?

Kirk