Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Difference between Worksheets. and Sheets. is...?
Hello all,
This question is just to satisfy my curiousity, as I don't (yet) believe it has a significant impact on my code. I came across something and I can't seem to find the answer. Everything I've found mentions 'how' to use the collection, and not 'why' to use it. If I use Sheets("Sheet1").Select, then the sheet is selected without error. If I use Worksheets("Sheet1").Select, I get a "Subscript out of range" error (run-time error 9). I haven't got the slightest idea why there's a difference. Any ideas? Appreciate anything you might have (ideas, links, suggestions). In most of my code, when accessing cell values I use: Worksheets("Sheet1").Cells(1, 1).Value = "some random string" This has never been an issue. Never really used ther Sheets Thanks, Jay |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Difference between Worksheets. and Sheets. is...?
Sheets include Chart sheets. Worksheets don't.
Hth, Merjet |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Difference between Worksheets. and Sheets. is...?
Well I'll be damned, that makes sense.
Thanks! Jay "merjet" wrote: Sheets include Chart sheets. Worksheets don't. Hth, Merjet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
difference of 2 cells from 2 sheets to appear on sheet 3? | Excel Worksheet Functions | |||
What is the difference beyween "Sheets" and WorkSheets" in subrout | Excel Programming | |||
sum difference cells on multiple sheets | Excel Worksheet Functions | |||
Difference between sheets and worksheets? | Excel Programming | |||
Any difference between Sheets Activate and Select? | Excel Programming |