View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default "Sheet" versus "Worksheet"

Excel has many types of sheet
Chart
Worksheets
xl4Macro Sheet
xl4 International Macro Sheet
DialogSheet
and in xl95 and xl5, Module sheets

I have never seen Sheets work where Worksheets doesn't if I am trying to
select a worksheet.



--
Regards,
Tom Ogilvy


Chuck Taylor wrote in message
...
When I need to switch from one worksheet to the other, I usually use
code like:

Worksheets("Sheet1").Select (or Activate)

But sometimes this just doesn't work unless I change it to:

Sheets("Sheet1").Select

Just for the sake of curosity, what's the difference between "Sheets"
and "Worksheets"? Excel help file isn't much help.

J