I'm trying to change the last line of this to that the formula is
=countif(lastcell:lastcoE2,RC-1)
but it inserts
=countif(E2:lastcell,RC-1)
how do I change the first bit?
LastCell = ActiveCell.Offset(-1, 0).Address
LastCoE2 = ActiveCell.Offset(-1, 1).Address
Offsetter = ActiveCell.Row - 1
Range(LastCoE).Select
ActiveCell.Offset(1, 0).Activate
ActiveCell.FormulaR1C1 = "=COUNTIF(R2C5:R" & Offsetter & "C5,RC[-1])"
=countif(lastcell:lastcoE2,RC-1)
but it inserts
=countif(E2:lastcell,RC-1)
how do I change the first bit?
LastCell = ActiveCell.Offset(-1, 0).Address
LastCoE2 = ActiveCell.Offset(-1, 1).Address
Offsetter = ActiveCell.Row - 1
Range(LastCoE).Select
ActiveCell.Offset(1, 0).Activate
ActiveCell.FormulaR1C1 = "=COUNTIF(R2C5:R" & Offsetter & "C5,RC[-1])"