to delete a worksheet
Dear Andrew
Lots of thanks!
Paul
"Ajtb" 撰寫於郵件新聞
...
Hi Paul
This will work, there is no need to select the sheet first.
Sub tt()
Application.DisplayAlerts = False
Sheets("ABC").Delete
Application.DisplayAlerts = True
End Sub
Regards
Andrew Bourke
阿三 wrote:
but want to ignore the warning message, please advise what should
I
add at the end of the following command? thanks
e.g.
Sheets("ABC").Select
Sheets("ABC").Delete
Paul
|