Hi,
I am writing a macro to autofill a formula down to the same number of rows as the row to the left of the cell that has been clicked on. I have found the below code to do this but it relies on the formula being entered only into row K and filling down to the number of rows in j. Is there anyway to write this so wherever the active cell starts, it will fill down the number of cells equal to the number of cells in the column to the left? In the data set I don't anticipate there to be blank cells.
Thanks,
Alexis
Bookmarks