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