subtotal at the end

[projectside]

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...

 

[Don Guillett]

lastrow=cells(65536,"e").end(xlup).row
cells(lastrow+1,"e").formula="=yourfomula"