Hi,
They both select all the sheets in a workbbok.
Whats the difference in these two statements?
Why Dim wkSht?
Why Sheets or Worksheets?
For Each Sheet In ActiveWorkbook.Sheets
Sheet.~~~~~~~
or
Dim wkSht As Worksheet
For Each wkSht In ActiveWorkbook.Worksheets
With wkSht
Thank you
Dave
Bookmarks