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