delete and rename sheets

hi,

how do you?

first
1. delete all sheets in the workbook that has a "2" at the end of its sheet name

then
2. rename all sheets that has no "2" at the end of its sheet name to having a "2" at the end of its name
ex:
sheet name "aaa" renamed to "aaa2"

3. but ignore the sheet named "DATA" - do not rename

Hi
try this:

Please Login or Register  to view this content.

thank you nicky and mike!