Run time error in code that extracts data from several sheets into master sheet

Hi Hello23

I can't duplicate this error...I'm able to manually add worksheets at will with the @ sign in the worksheet name. How are you adding the worksheets?

Everytime I add a new sheet with starting name @.... I get a runtime error

I suspect this error is raised later in the code.

This code (on my platform) eliminates the error and appears to resolve this issue

my unit number may be alphanumeric(like what we have now) or only NUMERIC so it should read both

Please Login or Register  to view this content.

I've not addressed this issue

If I make changes to existing project(sheets with @ symbol) it should automatically effect the master_database accordingly

See if the attached code works for you. If it does we'll deal with your remaining issue (I'll need more information regarding this remaining issue).

Different method.
Replace the code with the folloiwng

Please Login or Register  to view this content.