Reference Last Row in Sumif VBA

**jeffreybrown** · 03-20-2009, 04:56 PM

Hi,

I recorded this sumif in VBA, but know I am trying to figure out how to tie in the last row reference in place of the 27. Can somebody help with this?

=SUMIF($AR$2:$AR$27,$AR29,AS$2:AS$27)
FormulaR1C1 = "=SUMIF(R2C44:R27C44,RC44,R2C:R27C)"

**shg** · 03-20-2009, 05:01 PM

Last row reference?

**jeffreybrown** · 03-20-2009, 05:05 PM

Yes, my macro will add rows at each change in another value in the data so my sumif might be last row 27 one time and then the next time it could be last row 53.

**VBA Noob** · 03-20-2009, 05:17 PM

One way

Dim LastRow As Long
    LastRow = Cells(Rows.Count, "A").End(xlUp).Row
    ActiveCell.Formula = _
    "=SUMIF($AR$2:$AR$" & LastRow & ",$AR29,AS$2:AS$" & LastRow & ")"

VBA Noob