uktous
06-21-2012, 05:05 AM
Hi,
I want a macro will can perform the following function:
if sheets("sheet1") doesn't exist, then a message box will appear.
Could you please write me the macro?
My macro doesn't work.....
If Sheets("sheet1") Is Nothing Then
MsgBox prompt:="sheet1 doesn't exist"
End If
I want a macro will can perform the following function:
if sheets("sheet1") doesn't exist, then a message box will appear.
Could you please write me the macro?
My macro doesn't work.....
If Sheets("sheet1") Is Nothing Then
MsgBox prompt:="sheet1 doesn't exist"
End If