Sheets or Worksheets

[Piranha]

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

 

[JE McGimpsey]

The Worksheets collection contains only worksheets. The Sheets
collection contains worksheets and chart sheets.

 

[Piranha]

JE McGimpsey,
Thank you very much. That clears up that question for me.
All i can get to help me understand, is a good thing.
Thanks again
Dave