View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Zimski Bob Zimski is offline
external usenet poster
 
Posts: 30
Default 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