Why Worksheets(1) is an Object ?

[farshid_mi]

I am wonder why in excel VBA , Worksheets(1) returns an Object(variant) .
I expected that returning type will be a Worksheet object.

[xladept]

Have you answered your own question?

[xlnitwit]

Hi

Macro sheets are also part of the Worksheets collection.

[farshid_mi]

Have you answered your own question?

I don't know answer . and I want to figure out how VBA designer think about worksheets.

[farshid_mi]

Macro sheets are also part of the Worksheets collection.

No, If you have a macro sheet , you can not access it in worksheets collection. you can test it and see the following code doesn't show macro sheet name:

Please Login or Register  to view this content.

(I know sheets is a collection contains all sheets type like chart sheet , macro sheet , ... )

[Norie]

How are you getting Object from Worksheets(1)?

When I try this in the Immediate Window it returns Worksheet.

Please Login or Register  to view this content.

[farshid_mi]

How are you getting Object from Worksheets(1)?

When I try this in the Immediate Window it returns Worksheet.

Please Login or Register  to view this content.

If you type worksheets(1) , the list member dose not show . when VBE can not recognize object type it happens also you can see the tool tip when typing "Worksheets( " , in the tool tip you can see "_Default(index) as object " .
(I know that we can define a variable as worksheet to access member list in VBE but I want to figure out why worksheets(1) tool tip says it return Object and why we can not access its list member in VBE)

[shg]

Intellisense doesn't appear because the Worksheets method can return either a single worksheet (with all the usual properties or methods) or an array of worksheets, which have their own methods (like FillAcrossSheets)

That's why it's convenient to assign a worksheet variable.

[farshid_mi]

Intellisense doesn't appear because the Worksheets method can return either a single worksheet (with all the usual properties or methods) or an array of worksheets, which have their own methods (like FillAcrossSheets)

That's why it's convenient to assign a worksheet variable.

Thanks ,,,,,,,,,,,

[xlnitwit]

No, If you have a macro sheet , you can not access it in worksheets collection.

You are correct. Apologies- my memory failed me there.