VBA Adding copied rows after last used row

[yttgle]

Hi experts!

I have a worksheet which always has data in the A column (as part of a merged cell).

I am looking for a VBA program to help me select the last row and add a copyed set of 4 rows to add after the last row. The copyed selection will always be the same and origin from the same cells.

E.g.
- Select last used row (61 or Cell A61 as an example).
- Copy A1:F4 from different sheet
- Add copyed content to row 62:62 (A62:F65)

Next macro execution would add the same content to 66 etc.

Any way of solving this?

Br and thx!

 

[yttgle]

It works perfectly! It didn't fancy the merged cell so I dismerged it and shifted the "Add above" content to B.

Works just as intended - thx a million mole!

 

[mole999]

merged cells are a nuisance, have a look at centre across selection from the same format menu