Range referencing incorrectly
I seem to be missing how to reference celles properly, any help appreciated:
Dim i As Integer
For i = maxrows To 2 Step -1
Range("cells(i,1):cells(i,2)").Select
Selection.Cut Destination:=Range("cells(i-1,3):cells(i-1,4)")
Next i
|