does this help?

lastrow=cells(rows.count,"a").end(xlup).row

--
Don Guillett
SalesAid Software

"bodhisatvaofboogie" wrote in
message ...
I am not sure how to classify this problem.

I wish to autosum a column. Usually, clicking on the column at the top to
select the whole thing, then simply clicking the auto sum will place the
subtotal at the bottom of the page. WELL, the bottom of the page happens
to
be on line 65536. My document is only like 100 rows deep, so that makes
for
a lot of scrolling down LOL. SO, my question is:

How do I auto sum so that the subtotal will just appear in a blank cell
immediately following the last cell in the column with a value? I'm
trying
to put this into a macro, so that if I bring in a document that has 300,
500,
or any number of lines it will pick a blank cell at the bottom of the
column
with values and not on line 65536... :) THANKS!!!