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)