Hi, I am trying the following:
Sub FindState(LocalState As String)
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
If ws.Name <> LocalState Then
MsgBox "The state does not exist", vbExclamation
End
End If
Next
End Sub
But the problem is that whether the worksheet with the state name exists or not, it goes through the message1!!!!
Any advice is appreciated
Bookmarks