Code that will allow future changes to sheet tab

[g1terra]

I am using this code and need it modify in case someone modifies the sheet name (so it still works). So the code can run on the active sheet.

Any help is greatly appreciated!

Please Login or Register  to view this content.

[MarvinP]

Hi g1terra,

You need to use Sheet Codenames instead of the words on the sheet tab. Read the following site:
https://www.wiseowl.co.uk/blog/s112/...e-codename.htm

[g1terra]

This worked thanks so much!!