Solved: Formatting Cells within Print Range

Hello, I am looking for help with macro to format and resize cells in a print range. I would like to have a macro that asks the user to input "n" number of rows they need in the workbook, starting the rows on row 10(Rows 1-9 are repeat tiles). I would like to have this as a pop up window or be able to insert the number of rows in a cell and then click and button and it takes that number.

Then, the inserted rows would be resized to match row 10. Lastly, the print area would have to be updated to print n+1 rows because I have a border in the surrounding cells.

Please let me know if this is possible and how to do it, I am new to vba and macros as I am trying to learn.

I am using Excel for Mac 2011 and also Excel for Windows 2007, and 2010. Any help would be appreciated.

Post a workbook and show the before and after results if you can.

Try this,

This will not delete rows for you.

Try this,

Dave