Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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(D3:D8)") 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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How 2 sort an autosum total list after adding items 2 autosum item | Excel Discussion (Misc queries) | |||
Invoke hyperlink | Excel Programming | |||
Invoke Java from Excel | Excel Programming | |||
invoke a function | Excel Programming | |||
Invoke a macro with the Enter key | Excel Programming |