So I have a number of formulas that I have autofilling down to 15000 rows in this document as a "in case of" type measure. However, I only need to fill as far down as the last row where column D has any data in it. Here's an example:
Range("I8").Select
ActiveCell.FormulaR1C1 = _
"=IF(RC[-6]=""Normal"",IF(AND(RC[-1]>2,RC[-1]<30),R[-1]C[-4],""""),"""")"
Range("I8").Select
Selection.AutoFill Destination:=Range("I8:I115000"), Type:=xlFillDefault
I can't remember how to autofill based on last row of data. Using Excel 2013, and hoping to save my workbook some space/speed the macro up.
Bookmarks