Insert new row & prompt to ask how many rows to insert

[lady_kay]

Hi,

Hope you can help - im still just a learner in the world of macros & VBA code!

Im trying to insert a new row in my attached excel spreadsheet with the above rows formatting & validation rules, i have managed to copy the validation and formatting of a previous row but stuck on ensuring the last row is always copied - it picks up row 11 every time instead of moving down the page. I also want the macro to ask me how many rows to insert so i can add, say 10 rows at a time. Some of the columns are hidden & the cells with validation are highlighted in green with the list options to the right of the table.

Attachment 225095

I have tried previous explanations such as the below but receive error codes.

http://www.mrexcel.com/forum/excel-q...above-row.html

Thanks