Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
subtotal at the end
hi, i need a macro that would give me subtotal after finding the last cell. my spreadsheet every month has different number of data in it, and thus, different number of rows. I know i can do the subtotal manually but i already have other codes that i would run with it. I have multiple columns as well and i need the subtotal to start in column E, at last row. please help... ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
subtotal at the end
lastrow=cells(65536,"e").end(xlup).row
cells(lastrow+1,"e").formula="=yourfomula" -- Don Guillett SalesAid Software "projectside" wrote in message ... hi, i need a macro that would give me subtotal after finding the last cell. my spreadsheet every month has different number of data in it, and thus, different number of rows. I know i can do the subtotal manually but i already have other codes that i would run with it. I have multiple columns as well and i need the subtotal to start in column E, at last row. please help... ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal To Include Item Description On Subtotal Line | Excel Discussion (Misc queries) | |||
sort macro, subtotal and add lines after subtotal | Excel Discussion (Misc queries) | |||
pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
Bolding the subtotal lines automaticlly When using the Subtotal fu | New Users to Excel | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |