I'm trying to see if a worksheet is already created. If it is Im calling UserForm2, but if its not it will create the new sheet. When I do this I get "Compile Error: Else without If". Any help would be appreciated.
Code:
For k = 1 To Worksheets.Count
If Worksheets(k).Name = BorName = True Then
UserForm2.Show
End If
Exit For
Else
Worksheets.Add(After:=Sheets(Sheets.Count)).Name = BorName
Exit For
End If
Next k