Finding Cells with data

[Lenny]

I have a workbook in which I import data into column L. I have a formula for the column. The issue is sometimes there is a large difference in the amount of rows that are imported into the column. Is there a way for excel to automatically autofill my formula into the cells with data so I don't have to do it manually everytime.

Thanks

[Dave Hawley]

Hi Lenny

There is bound to be, how about something like:

Range("L2", Range("L65536").End(xlUp)).FormulaR1C1 = _
    "=SUM(R[-2]C[1]:R[7]C[1])"

Or if the formula goes into the next column use:

Range("L2", Range("L65536").End(xlUp)).Offset(0, 1).FormulaR1C1 = _
    "=SUM(R[-2]C[1]:R[7]C[1])"

[Colo]

Hi. If you have Formulas in columns "M",
Please copy this into a standard module.

Sub MyAutoFill()
Range("M1").AutoFill Range("M1", Range("L65536").End(xlUp).Offset(, 1))
End Sub