Forum Discussion
Macro
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, t...
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.