activesheet as object!

[lezawang]

Hi
Excel defines ActiveSheet as following: (using object browser)

property Activesheet as Object
Read only
Member of Excel Application

My question, what does object means here? I thought the correct definition should be

Activesheet as Worksheet

Thank you very much.

 

[JLGWhiz]

ActiveSheet is a VBA Constant and is an object. It does not need to be declared as a worksheet because the VBA application already knows that it is. If you are using user defined variables like 'mySheet' to represent a worksheet, then you would need to declare it

Dim mySheet As Worksheet

Worksheet is an object and is part of the Sheets and Worksheets collections.