ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   When is a parent object required for a property? (https://www.excelbanter.com/excel-programming/428423-when-parent-object-required-property.html)

[email protected]

When is a parent object required for a property?
 
A perfect example of this question is the Help for the Cells
property. It says that in expression.Cells, the object specifier
"expression" is required, regardless of whether it refers to an
Application object, Range object, or Worksheet object. However, there
are plenty of examples where "Cells" is not prefixed with an object
specifier. In fact, the very Help page for Cells contains such an
example.

Where can one find clear rules specifying when the object specifier is
truly required, and what the implied object is when the object
specifier is not present?

[email protected]

Solved: When is a parent object required for a property?
 
May bad. I'm not reading the help slowly enough. It is described in
the Remarks. Sorry for jumping the gun.


All times are GMT +1. The time now is 12:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com