I have a macro that references the sheet tab name that I have given it. The problem is these Tab names change periodically, And that means I have to run a find and replace function to change my Macro with these tab names with the new names. When I look at the module in the Macro screen they show sheet1=(my Name). But what i need is to reference my macro to the Excel default name sheet1, sheet2, sheet3,...etc. I hope I explained my issue.
Thanks for any help
Bookmarks