View Single Post
  #2   Report Post  
Bill Manville
 
Posts: n/a
Default

Not sure I follow the scenario.
How about recording your actions when doing it manually, using the
macro recorder.
If there are then issues you need to address you can post the code and
ask about the specific issues.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup