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.....
[VBA]
If Sheets("sheet1") Is Nothing Then
MsgBox prompt:="sheet1 doesn't exist"
End If
[/VBA]