Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by smanguns
-
Check if Sheet exists
You can use also the following function Public Function IsSheetExists(sname) As Boolean Dim x As Object On Error Resume Next Set x = ActiveWorkbook.Sheets(sname) If Err = 0 Then IsSheetExists = True _ Else IsSheetExists = False End Function have fun Sandra- smanguns
- Post #6
- Forum: Microsoft VBA - Visual Basic for Applications
