I have worked out how to rename worksheets (yay!)
But now am having a slight issue with an IF statement and was wondering if anyone would help.
If the very first sheet of the workbook is named "Sheet A", then I first rename the 3rd sheet to "Sheet X" and then rename "Sheet A" to something else. I don't know how to test the condition.
Can someone help?