VBA Excel 2000 - Rename sheet if that exist
Posted on 2011-03-25
In a file it can happen that there are two sheets "Domestic" and "Export", but also that any of them does not exist or just one of them.
Could you please how to write a macro which would be able to identify what is the actual scenario, and based on that rename any of them to "Total"?
With IFs would be imagined like this
- if "Domestic" exist then rename it to "Total" (if also exist "Export" than just leave it unchanged)
- if "Export" exist then rename it to "Total" (if also exist "Domestic" than just leave it unchanged)
- if any of them does not exist then add a sheet as "Total"