Copy data in a macro.

[jfaz]

I have recorded a macro to copy formula from one cell to a range of cells
using end and down arrow key in the macro to pick up the last record based on
the column to the left, this has dropped into the macro the last cell
reference. How can I include in the macro to copy to the last record line
(which could be variable)

 

[Mike H]

Hi,

Copies the last used cell in column A.

Sub versive()
Cells(Rows.Count, 1).End(xlUp)(1).Select
Selection.Copy
End Sub

Rows.Count, 1) change 1 to to for col B etc

Mike