On 16 nov, 01:11, Bob Zimski
wrote:
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

Hello,

It seems to be Range(cells(i,1),cells(i,2)").Select instead of Range
("cells(i,1):cells(i,2)").Select

Hope this helps

Regards