Perhaps:
![]()
Cells(Rows.Count,"B").End(xlUp).Offset(2).Formula = "=SUM(R2C:R[-1]C)"
Perhaps:
![]()
Cells(Rows.Count,"B").End(xlUp).Offset(2).Formula = "=SUM(R2C:R[-1]C)"
Last edited by DonkeyOte; 10-15-2009 at 08:43 AM. Reason: typo - cells not range
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks