Hello,
I have 20 worksheets all with the following as code to name the tabs:
This works fine, unless A1 is 0 for more than one sheet. How can I edit the code for each sheet to display a number (specific to the sheet) if there is an error?Please Login or Register to view this content.
For example, Sheet one could be changed to 0 if error, sheet 2 could be 1 if error and so on. Thanks for your help!!!
Bookmarks