workbook search stoped working

[TheNewGuy]

I thought I had this working for me but I think I made a change some where that is messing it up. Also my workbook is getting so big that it is getting harder to test each piece. and as I don't exactly understand the "with" command I am hoping that someone can look at this real quick and see where I messed up. so here is the code:

Please Login or Register  to view this content.

The problem is that when it doesn't find a match on the first worksheet it looks at, it then calls the sub program "NoDatabasePart" before searching the rest of the workbook. Please if you have a suggestion let me know and I will try it.
Thank you very much for your time.

[shg]

What is Me supposed to refer to?

More generally, what is the code supposed to do?

[TheNewGuy]

What is Me supposed to refer to?

I think the .ME refers to the worksheet that matches the rFind.

More generally, what is the code supposed to do?

The code is supposed to open a workbook then search each worksheet in that workbook for a match located in column A. And the value I am trying to find a match for is located in TEXTBOX14.
I really hacked this code together, but I thought I had it working,....but I guess not.

[TheNewGuy]

I believe I may have fixed it. The offending line of code seems to have been the else:call nodatabasepart

Please Login or Register  to view this content.

so I guess I got it but.....we'll see!
Also, you were right I did not need the .ME part of the code.
Thanks again for all your help.