I'll try some quick definitions for you.

An OBJECT is a tangible thing, a building block or component of Excel.
Such as Workbook, Worksheet, Range and many more.
In the visual basic editor, type Object Model in the help box, you will find a listing of
the Excel objects (and others).

A PROPERTY is a characteristic of an object.
A METHOD is an action that can be taken.

You could consider a kitchen Stove as an object (one of the components of a kitchen).
It would have properties such as color, burners, drawers.
A method might be the On method for a burner... Stove.Burner.On = True
It can get a little confusing when you consider that the stove burner is an object in its own right. (that is the burner property
returns an object)

A VARIABLE (according to John Walkenbach) "is simply a named storage location
in your computers memory" (not much help?)...
You could consider a variable as a custom name that you use to refer to something.

I strongly suggest you buy a reference book.
I like John Walkenbach's Power Programming books.
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"mwam423"

wrote in message dear mr. thomlinson (i've used your code in the past) and mr cone, is there
any resource that explains the difference between an object and a variable,
as well as difference between properties and methods in a quick and concise
way. i know some of the bugs i run into deal with these differences.
thanks, and have a great weekend!