Forum Discussion
Adding specific rows in Excel with VBA
Hello everyone, I am trying to create a macro that adds specific rows in Excel/at a specific position. For visualization see screenshot below. Basically what I´m trying to do is by clicking "button...
Sub Button3_Click()
Dim r As Range
Set r = Range("A" & Rows.Count).End(xlUp).Offset(2)
Range("A9:J11").Copy Destination:=r
Application.CutCopyMode = xlCopy
End Sub
HansVogelaar : fantastic - thanks a lot