Skip to content

Instantly share code, notes, and snippets.

@imamuddinwp

imamuddinwp/Check Sheet Exist or Not In Excel Work Book

Last active May 14, 2020 02:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save imamuddinwp/8c013c8be1f92f7a58a162b7da469c8d to your computer and use it in GitHub Desktop.
Save imamuddinwp/8c013c8be1f92f7a58a162b7da469c8d to your computer and use it in GitHub Desktop.
Download ZIP
Check Sheet Exist or Not In Excel Work Book, thanx :) Imam Uddin; imamcu07
Raw
Check Sheet Exist or Not In Excel Work Book
Sub Check_Sheet_Exist()
Dim ws_exist As Worksheet
On Error Resume Next
Set ws_exist = Sheets("My Sheet")
If Err.Number <> 0 Then
MsgBox "Please Check Sheet 'My Sheet' exist or not!!! Thanx :)"
Else
'------------------------All Code Goes Here
'---------------------------------
End If
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment