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/

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/