troubleshooting Question

Difference between Excel Object Property and Method

Avatar of KenHadley
KenHadleyFlag for United States of America asked on
Microsoft Excel
6 Comments2 Solutions266 ViewsLast Modified:
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?
Join our community to see this answer!
Unlock 2 Answers and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros