I used the offset function, but still can not get the cells to move horizontally. Vertically is not a problem. Here is the code that I have so far:


Worksheets("AFE Days & Cost").Activate
Range("N6").Select
Selection.End(xlDown).Select
ActiveCell.Offset(RowOffset = 0, ColumnOffset = 3).Activate
Selection.Copy
Range("F29").Select
ActiveSheet.Paste

By changing the RowOfset to any number the selected cell moves accordingly, but the ColumnOffset value has no effect.