woesofwomen
07-25-2014, 12:07 AM
Hi Guys,
I have a code below that help me to rename a worksheet. But what if that worksheet name already exist while running the code and wish to skip that step so it wont return an error.?
What code can i add to aid me.
Sheets("Sheet1").Name = "Final"
I have a code below that help me to rename a worksheet. But what if that worksheet name already exist while running the code and wish to skip that step so it wont return an error.?
What code can i add to aid me.
Sheets("Sheet1").Name = "Final"