many thanks to Trevor, Rob and George
Ah, the finer points of VBA. You were right gentlemen, I needed to insert
an explicit reference to the worksheet so that VBA would understand which
worksheet contained the Cells.
Thank you for showing me how to overcome that problem, and for illuminating
this subtle point about object references.
All my best,
Paul
|