Identifying objects, properties and other things

Here is the first line of a FOR loop:

For Each rw In Worksheets(1).Cells(1, 1).CurrentRegion.Rows

1. Worksheets(1) is an object right?
2. Cells (1,1). Is that a property of the Worksheets object?
3. What is CurrentRegion, an object or property? An object or property of what?
4. What is Rows, an object or property? An object or property of what?


I always thought that you had an object, then within an object a property or method. I didn't think it was possible to go down to "a lower level" after the property or method.

Please Login or Register  to view this content.

Cells is a property of the Worksheet object that represents a range on the sheet (A1 in our case)
CurrentRegion is a property of a Range object that represents another object Runge
Rows is a property of the Range object, which represents all rows of a range.

ie property provides an object or other property. You can specify some value for the property.
The method is an action that is performed on the object