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


--
Piranha
------------------------------------------------------------------------
Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435
View this thread: http://www.excelforum.com/showthread...hreadid=374763