I'm learning how to use the "Cells.Find()" VBA function. I have th
following simply routine:
sub Test()
Call FindStr("Mystring")
end sub

sub FindStr(strx as String)
Cells.Find(What:=strx).activate
end sub

When I run the Test() sub. I received the following error:

Run-time error '91':
Object variable or With Block variable not set

Can someone please
1 - tell me what am I missing here to get this simply routine workin
?
2 - where can I find more documentation on this Cells.Find() functio
?

Thanks in advance for any assistance

--
Welli
-----------------------------------------------------------------------
Wellie's Profile: http://www.excelforum.com/member.php...fo&userid=1537
View this thread: http://www.excelforum.com/showthread.php?threadid=27403