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.
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