LinkBack URL
About LinkBacks
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)"
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)"
Last edited by VBA Noob; 03-20-2009 at 05:59 PM.
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks