Hi, I am trying to copy a range below another one......
I have defined two ranges as follow:
Dim r1 As Range
Dim r2 As Range
Set r1 = Sheets("Old Index").Range("A9:A200, H9:H200, K9:K200")
Set r2 = Sheets("New Index").Range("A9:A200, H9:H200, K9:K200")
I first copy the first range into another sheet by doing this:
r1.Copy Sheets("Trades").Range("A5")
now I want to copy the r2 range but it should use as the first cell, the one below the last one used by r1.......
How can I do this? Any help will be greatly appreciated!
thanks,
Fer