run time error '91'
 

the most common suggestion is to check to see what happened:

Sub Testme01()
Dim FoundCell As Range

with activesheet
Set FoundCell = .Cells.Find(what:="what???",...rest of find command)
If FoundCell Is Nothing Then
'it wasn't found
Else
'it was found
End If
end with
End Sub

And this looks kind of scary to me:
*/07/04 00

If your field really has an asterisk in it, you may want to look for:
~*/07/04 00

~* means to find the asterisk character. Without that leading tilde, the
asterisk will be used as a wildcard. (maybe that's what you want, though.)



tina wrote:

My problem is I recorded a macro with find in but when i ran it later I get
error message "object variable or with block variable not set"

the part of macro it errors on is as follows
Selection.Find (What:="*/07/04 00", After:=Activecell, LookIn:=xlValues, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False).Activate

when recording it works fine
Any ideas would be much appreciated
Thanks
Tina

--

Dave Peterson