[SOLVED]Run-Time Error 91

[tcobb64]

I've done a lot of searching, but to no avail. I'm not real familiar with macros and the one I have is one I found that is close to what I need. I have a workbook with several worksheets. I want to search through each worksheet and have the results posted to a new worksheet. What I have works unless the word I'm searching for doesn't appear on a worksheet and I get the run time error at that point.

Here is the code:

Please Login or Register  to view this content.

The error occurs at:

Please Login or Register  to view this content.

[romperstomper]

You need to test the function return:

Please Login or Register  to view this content.

[tcobb64]

That fixed the problem! Thanks for your help. For some reason, though, it duplicates the findings and the new spreadsheet. This is a minor inconvenience though.

[ChrisKader]

If you feel that your problem was solved, please change the title of the post to [SOLVED].

Thanks!

[romperstomper]

It should not duplicate anything. What actual code see you using now?

[tcobb64]

Here's the code now. What it does is creates a new worksheet and lists the results twice. If that makes sense. Example, I get the results listed lines 1-10 and then repeated lines 11-20.

Please Login or Register  to view this content.

[romperstomper]

Your code loops through every sheet which includes your output sheet, which I think is why you are getting the same data twice.