I had a quick course on macro and I would like to write my first one, but I would need some help with it.
Id like a macro which copies the selected cells to a new worksheet. Id like it to copy under each other as many times, as the user gives in a msgbox.
So far I am at this stage, but cant figure out how to copy them under each other:
' Copy_Paste Macro
Dim i As Integer
Dim j As Integer
i = InputBox("Enter number copies to insert", "Paste")
For j = 1 To i
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _