"Find Property of the Range Class"

[yippie_ky_yay]

Hello Forum,

I have been trying to implement a search across all worksheets using examples found in this forum.

I have tried a couple, but always get:
"Run-Time Error 1004: Unable to get the Find Property of the Range Class". And, as suspected, in the debugger the line with ".Find" in it is what is highlighted.

I am using '97 - any thoughts on what I may be doing wrong.

Any help would be greatly appreciated!

-Sean

 

[Richie(UK)]

Hi Sean,

Could you post the offending routine for us to look at?

EDIT: Never mind. Anyone looking here please follow this link:
http://mrexcel.com/board/viewtopic.php?topic=22395&forum=2&6

_________________<font color="blue"> «««<font color="red">¤<font color="blue"><font size=+1>Richie</font><font color="red">¤<font color="blue"> »»»</font>

</gif>
This message was edited by Richie(UK) on 2002-09-17 11:37

 

[yippie_ky_yay]

Please accept my apologies - I posted this question twice by accident. I was able to solve the problem with the help of Andrew Poulsom.
http://www.mrexcel.com/board/viewtopic.php?topic=22395&forum=2&6

-Sean