Thread
:
subtotal at the end
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
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 With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]