Hi, am hoping that this is a reaal easy quick one for you guys....

I need a macro (can be done by using a button) where a range within a row is copied and pasted below this range. The number of copies/replicated rows need to be based upon a number that is input into another cell.

So if A1 equal 5, then range A5:A10 is copied and pasted below this row 5 times.....

I have played around several times and done a few searches within this forum but cannot seem to find a similar post...

thanks in advance