Hello to all.
each time a new row is inserted, insert these formulas in the J/L column
Sub rimetti_formule() Range("J4:J1000").Select ActiveCell.FormulaR1C1 = "=IF((RC[-2]*RC[-1])<>0,RC[-2]*RC[-1],"""")" Range("L4:L1000").Select ActiveCell.FormulaR1C1 = _ "=IF(ISERROR(IF((RC[-2]*RC[-1])<>0,RC[-2]*RC[-1],"""")),"""",IF((RC[-2]*RC[-1])<>0,RC[-2]*RC[-1],""""))" 'Range("L4").Select End Sub
Bookmarks