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

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

"Alan" schrieb im Newsbeitrag
...
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

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

"Alan" schrieb im
Newsbeitrag
...
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

.