Occasional Visitor

is there a way in a macro to select the last cell in an array, then move down to the next empty cell, paste the data in that cell, which is a different cell each function. When recording the macro, the data always wants to paste to the same cell. It needs to paste below the current data and add to the list, not replace current data. Can anyone help if i have explained it right... I hope. Thank You

1 Reply


Since you don't provide any specifics, I can only give an example:

    Range("B1").Copy Destination:=Range("D" & Rows.Count).End(xlUp).Offset(1)

This copies cell B1 and pastes it below the last used cell in column D.