davegugg:
When I paste that code into my Macro I get "Run-time error '1004': Application-defined or object-defined error, and when I click on the Debug option it highlights the portion of your Coded that I copied into my Macro over the previous one...