Check to see if a Tab named "XYZ" exists.

[gheyman]

I need to check and see if there is a Tab named "BOE_Temp" if it doesn't open a hidden tab named "BOE_Temp2" make a copy and rename the copy "BOE_Temp"

My biggest hurdle is code for checking if the tab is there or not.

 

[steve the fish]

Heres a way to test if sheet exists:

flag = False

For Each sh In ThisWorkbook.Worksheets
If sh.Name = "BOE_Temp" Then flag = True
Next

MsgBox flag