subtotal
i need to run a code that would subtotal my spreadsheet. my problem i that I won't know what my real last cell is because the spreadshee will have different number of data everytime i run the report. i need the subtotal to be in column E through L and the row number wil be whatever the real last cell is. please hel ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
subtotal
This will sum the E column for example
This formula will be two cell below the last value Range("E" & Rows.Count).End(xlUp).Offset(2, 0).FormulaR1C1 = "=SUM(R1C:R[-2]C)" You can make a loop through your columns -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "projectside" wrote in message ... i need to run a code that would subtotal my spreadsheet. my problem is that I won't know what my real last cell is because the spreadsheet will have different number of data everytime i run the report. i need the subtotal to be in column E through L and the row number will be whatever the real last cell is. please help ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
All times are GMT +1. The time now is 10:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com