Difference between sheets and worksheets?

  • Thread starter Thread starter Alan
  • Start date Start date
A

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
 
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
 
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



.
Click to expand...
 
Back
Top