copy multiple rows below the last multiple times

[vanuxem]

Hi all,

In Excel 2016, I would like to copy and insert a fixed amount of rows (containing formula's and graphs), by a value, which I have entered.

For example: a pop up displays, or I enter a number: 'how many tables do you have?' : enter x amount of tables.

Then the macro automatically copies every time the same rows, which I have selected in the macro,

and inserts them x times, starting at the first rows which is blank.

can somebody give me the macro code to do this?

thanks

Alex