I am using the following code below for one excel file
But when I copy the Macro to another excel file, instead of Table, it is List![]()
Set Rng = Sheets("_003_Table").Range("A1").CurrentRegion
is there any way to tell the Macro to only look for the tab label as "_003" in the beginning and NOT telling it to use the active sheet.![]()
Set Rng = Sheets("_003_List").Range("A1").CurrentRegion
Since with my Macro i have it creating Pivot tables and charts
Bookmarks