ranger2.select

  1. M

    Excel Macro: How to total a column with changing lenghth

    How do I have the macro automatically calculate a column where the row number length changes: (Below is my macro) Range("R2").Select Selection.End(xlDown).Select Range("R2333").Select ActiveCell.FormulaR1C1 = "=SUM(R[-2331]C:R[-1]C)" Range("R2334").Select

Some videos you may like

This Week's Hot Topics

Top