Ivan about message 18095.html

Posted by Paul on January 28, 2002 6:15 PM

Ivan the number search works GREAT but when I enter text to search for I get "type mismatch" for "If SearchValue = "" Or SearchValue = 0 Then Exit Sub" in the code any ideas. Thanks

Posted by Ivan F Moala on January 29, 2002 2:46 AM

Re: Ivan about message 17980.html

Paul sorry...your using excel 97 change to
If SearchValue = False Then Exit Sub.

Note I have updated it since.

HTH....if not Repost

cheers

Ivan

Posted by Paul on January 29, 2002 5:19 AM

Ivan, Works Great! Thanks (NT)