P
PeteCresswell
I've got a cell selected.
Now I'd like the macro to invoke the AutoSum icon (the little sigma..)
that sums the columns above the selected column.
But when I try to record a macro, it comes up with the result of the
AutoSum (e.g. "=SUM(D38)") instead of a call to AutoSum.
Is there a way?
The agenda is tb able to create a sum per the rules built into the
AutoSum icon and make it bold with a single Ctl+(letter) stroke.
I guess the obvious is to start at the selected cell, iterate upwards
until a blank cell is found, and then do an =Sum() of what's between.
But before I did that, I wanted to see if I was missing something with
AutoSum.
Now I'd like the macro to invoke the AutoSum icon (the little sigma..)
that sums the columns above the selected column.
But when I try to record a macro, it comes up with the result of the
AutoSum (e.g. "=SUM(D38)") instead of a call to AutoSum.
Is there a way?
The agenda is tb able to create a sum per the rules built into the
AutoSum icon and make it bold with a single Ctl+(letter) stroke.
I guess the obvious is to start at the selected cell, iterate upwards
until a blank cell is found, and then do an =Sum() of what's between.
But before I did that, I wanted to see if I was missing something with
AutoSum.