Application Class

[lezawang]

Hi
Using Object browser, Application class has the following:

Activecell as range
Activechart as chart
Activesheet as object
Activeworkbook as workbook
ActiveWindow as winodw

All of them make sense to me except ActiveSheet? Why is define as Object? What does that mean? Why they did not define it as

ActiveSheet as Sheet

Thank you.

 

[mikerickson]

ActiveSheet could be a Worksheet object or it could be a Chart object.
Don't know why they prefered Object to Sheet.

 

[Rick Rothstein]

Why they did not define it as

ActiveSheet as Sheet

Because "Sheet" is not a data type that variables can be declared as. If you type this...

"Dim SomeVariable As"

into the module's code window, when you type a space character after the "As" keyword, there will be no item in the list of data types named "Sheet". There are "Sheet1", "Sheet2", etc. which are specific sheets, but there is no general "Sheet" item (the item is Worksheet, but that is a specific type of sheet, not a general sheet covering worksheets, charts, etc.).