Not getting error message I need, instead getting Out of Range Error (Error 9)

Hello everyone! I'm new to the forum, but have been using it for many of my projects over the past few months. In the company i work for we cannot get Microsoft Access so I am basically circumventing this issue and creating our own database using multiple excel files. There are about 12 files talking to each other, and so far the only issue i have run into was the below. Since i can't search tab names easily, I just am opening the database, and then the tab based on user input which will be a machine's serial number. The database will have a separate sheet for each machine that is QC tested, and where I've run into an issue is in the error. Instead of returning the error message I want, I get "Subscript out of range (Error 9)".

Please Login or Register  to view this content.

Hi, welborns2,

shift the GoTo before the Activate:

Please Login or Register  to view this content.

Ciao,
Holger