as mentioned, Value is the defualt property, and while it
can be omitted in VB6/VBA, using it does make code more
legible.

However .NET object have no defualt value. If your
current code uses the .Default methods & properties, then
it will make re-factoring your code so much easier.


Patrick Molloy
Microsoft Excel MVP
-----Original 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"?