how to skip a VBA code if it already exist - Rename worksheet

[woesofwomen]

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"

[Bob Phillips]

Off the top


Set ws = Nothing
On Error Resume Next
Set ws = Worksheets("Final")
ON Error Goto 0
If ws Is Nothing Then Worksheets("Sheet1").Name = "Final"