dot value
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"?
|