I have the below Macro to input a formula in cell J2. How can I get the macro to input this formula in all cells below J2 that contain text in the adjacent cell (the cell located in column I)?
Range("J2").Select
ActiveCell.FormulaR1C1 = "=(RC[-6]-RC[-5])*1440"