In article ,
says...
The macro works perfectly. I had to move the "Do" command down one line
and you were right the "Cell.Set" was the line causing the run-time
error. Thank You for your help, it is greatly appreciated! One more
question, is it possible to stop or cancel the macro while its running?



Yes, you can interrupt a macro as long as the developer has not
disabled that capability. Use ESC or CTRL+Break.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions