Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have figured out that the Worksheets and Sheets
properties both return a Sheets collection, not a Worksheets collection. How do I then create a Worksheets collection, that is a collection including only worksheets but excluding chart sheets? By the way, is there any logical explanation for why the Worksheets property was designed to return a Sheets collection and not a Worksheets collection? I find this to be one of the most CONFUSING aspects of working with Excel VBA. Tony Lin Fremont, CA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
add to insert object create new list | Excel Discussion (Misc queries) | |||
Activex component can't create object | New Users to Excel | |||
How do i assign the ActiveWorkbook.Worksheets to a worksheets object? | Excel Worksheet Functions | |||
CREATE LIST OBJECT IN EXCEL | Excel Worksheet Functions | |||
activex component can't create object with SAP 6.20 | Excel Programming |