Difference between sheets and worksheets?

[Alan]

What's the difference between sheets and worksheets? When
should I use one rather than the other?

The following code implies there's no difference:

Dim ws As Worksheet
Set ws = Sheets(1)
ws.Select
Set ws = Worksheets(2)
ws.Select

Regards,
Alan

 

[Frank Kabel]

Hi
the sheets collection also includes chart pages, Excel4 macro pages,
etc. The worksheets collection only worksheets
So in most cases you won't note a difference

 

[Guest]

Thanks Frank.

-----Original Message-----
Hi
the sheets collection also includes chart pages, Excel4 macro pages,
etc. The worksheets collection only worksheets
So in most cases you won't note a difference

--
Regards
Frank Kabel
Frankfurt, Germany



.