Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Sheet" versus "Worksheet"
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Sheet" versus "Worksheet"
"Tom Ogilvy" wrote in message ... 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 This might explain why it doesn't always / ever work for a chart sheet though? I guess you are saying that Excel sees them as unique or separate objects? Alan. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Sheet" versus "Worksheet"
Sure - they are separate objects
you can't Dim sh as sheet You have to do Dim sh as Object for each sh in sheets dim ch as Chart for each sh in Charts dim ws as Worksheet for each ws in Worksheets I don't know what you mean by doesn't work. -- Regards, Tom Ogilvy Alan wrote in message ... "Tom Ogilvy" wrote in message ... 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 This might explain why it doesn't always / ever work for a chart sheet though? I guess you are saying that Excel sees them as unique or separate objects? Alan. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Excel "Move or Copy" and "Delete" sheet functions | Excel Worksheet Functions | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |