Avatar of KenHadley
KenHadley
Flag for United States of America asked on

Difference between Excel Object Property and Method

In trying to understand the Excel Object Model, I wonder why the terms Method and Property are used inconsistently. I have some experience in the Java world, where the Property of an object is always what something *is*, while a Method is always something the object *does* (or is done to it).

This obviously occurs in the Excel Object Model as well, but sometimes I get surprised. For example, there is a Resize method for a ListObject object. Makes perfect sense. However, the Range object has a *Property* called Resize that appears to *do* the exact same thing. Why would this be called Property in the model. Am I missing something?
Microsoft Excel

Avatar of undefined
Last Comment
KenHadley

8/22/2022 - Mon
no worries :-) no nothing


ListObject.Range is read only and represents the range to which the ListObject applies

ListObject.Resize enables the ListObject  to be resized over a new range

Patrick Matthews

KenHadley,

Resize is redefining what the Range object is, so on that basis at least I guess you could say it meets your definition of a property.

:)

Patrick
SOLUTION
Patrick Matthews

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
no worries :-) no nothing

Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER CERTIFIED SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
KenHadley

ASKER
Thank you for the responses. The inconsistency in the OM is unfortunate, but as long as I know I am not missing something important in the OM, we can make it work.