View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Paul James[_3_] Paul James[_3_] is offline
external usenet poster
 
Posts: 58
Default 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