Stuart,

Invariably, an object has a default property. If you do not specify a property, the default is assumed.

I personally try to avoid the default and specify all properties. I find this causes less confusion, is more explanatory, and is likely to cut down on simple errors.

As you may have guessed. Value is the default property of the Range object, of which Activecell is an instance.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Stuart" wrote in message ...
I have noted that the MVP members always include .Value when reffering to a cell. eg.

if activecell.value= 5 then

for years I would have just used (and have never had any problems) with.

if activecell=5


What are the bennifits in specifying "Value"?