Understanding the Excel Object Model; ActiveCell as an example

**Excel_vba** · 06-18-2013, 03:38 PM

The following webpage seems to imply that ActiveCell is a property of the Application object.
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

The attached Word file contains a screen shot of the Object Browser. I have ActiveCell selected. At the bottom it seems to indicate that ActiveCell is a property of the Range object. So is ActiveCell a property of the Range object or the Application object?

1. How do you read the descriptions at the bottom? Another example, under the Global class, select Date and it says property Date as Variant. What does this mean?

2. How do classes tie into objects?

**Jakobshavn** · 06-18-2013, 03:56 PM

Interesting question.

ActiveCell is a property of both Application and Window.

It is a Range Object, a special range - the Selected cell on the active worksheet of the active workbook

run:

Please Login or Register  to view this content.

**Excel_vba** · 06-18-2013, 04:13 PM

That is where I am confused. How could something be a property and an object at the same time?

**Jakobshavn** · 06-18-2013, 04:24 PM

You are correct!

ActiveCell is an Object (a Range Object)
ActiveCell (like all ranges) has properties
The Address property of ActiveCell is a string variable
The Parent property of ActiveCell is a worksheet (which itself is an Object)