Not just 100% sure just waht you are looking for so here is a possible
solution.

msgbox application.sum(range(sheet1.range("A1"), _
sheet1.range("A65536").end(xlup))

on the other hand you could just sum the entire row
msgbox application.sum(sheet1.range("A:A"))

with the same result...
--
HTH...

Jim Thomlinson


"BamaBarks" wrote:

In Lotus, I could ask the macro to total a variable group of rows w/ an .end
up command. Can an Excel Macro be written to total variable rows?