HELP! Sh as Worksheet
Hi,
I'm a newbie and as having trouble grasping something. I'm running code to
delete all empty sheets in a workbook. The code I have found begins with
Dim sh as Worksheets
For Each sh in ThisWorkbook.Worksheets
If Application.WorksheetFunction.Counta(sh.cells) = 0 Then
application.DisplayAlerts = False
sh.Delete
Application.DisplayAlerts=True
End if
Next
My questions is:
What does the sh as Worksheet mean in plain English?
I assume the Displayalerts means don't show me the confirmation message to
delete sheets
Thanks!
--
Thanks!
Dee
|