Macro To Copy Data, Paste, Then Increment In Order To Duplicate Functionality

Hello,

I've been searching and found bits a pieces of the answer I need but could use some more direct help. I'd like to copy and paste a series of cells, their data, styling, form controls, etc.

I've managed to do this a single time but am having trouble getting a variable built that will allow the cells to be duplicated over and over upon button click.

Please Login or Register  to view this content.

This will accomplish the goal once but I need help creating a variable that will increment 5 more rows each time the macro gets run off of a button click.

Thank you!

You're wanting the range A4:I22 to be copied and pasted.

Where are you wanting it pasted at?

Are you wanting the range of cells pasted each time you click your button with 5 rows between each?

Not sure if this is what you're looking for.