How do I sum variable rows in a macro?
 

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?

How do I sum variable rows in a macro?
 

What makes the number of rows variable? A blank cell? I think you
need to provide a few more details.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"BamaBarks" wrote in
message
...
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?

How do I sum variable rows in a macro?
 

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?