Thanks for your help. I'm looking to copy certain rows and maintain the
formatting. When you click on a cmd button I would like a box to come up and
ask for how many rows do you want to copy. Then, copy the entire rows from
say A10 and paste to A20 and placing the amount the user asked for.

I also would like to be able to go back many times and add rows..so if I add
6 rows...do work somewhere else in the sheet or workbook and come back and
add an additional 2 or 3 or mor.