Hi Ted,

To avoid potential, somtimes subtle, problems ranges should always fullly be
qualified.

As with any range object, uqualified references will be interpreted by VBA
as relating to the active sheet or, in the case of a sheet module, relating
to the sheet holding the code.

---
Regards,
Norman



"TedS" wrote in message
...
Is there a definitive unambiguous write-up of issues using the "cells"
property.

The help definitely implies an issue where is says it has to be referenced
as ".cells" if anything other than the active sheet is being referenced.
I
fixed one problem this way by making the sheet active.

I have "cells" all over my code and I'm pretty sure this is causing me
pain
of the 1004 variety.