err 91 on cells.find

[DonW]

hey there all powerful gurus of the Excel world. lol

I've run across something that is coming up intermittently and don't know why..
I'm accessing another file to find a value, based on that value, I get data I need and pop it into "thisworkbook".

Please Login or Register  to view this content.

myqa is the value I'm trying to find in the external file.
Intermittently, I'm getting a err 91 when myqa is not on the worksheet. However, other values for myqa, if not found, the On Error GoTo takes over.

Rest of code

Please Login or Register  to view this content.

Any suggestions?

[DonW]

ha! found it.....I forgot to clear the error handler.
Love it when a plan comes together......

Please Login or Register  to view this content.

Thanks for anyone's time that was looking in to this.

[AB33]

You will get many errors until you set up the find function correctly. You are just merely hiding the erorrs.

It should be set to a range.

Please Login or Register  to view this content.