Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How get sum value in status bar?
Thanks for all help.
Is there a variable or method that gets me the value of the sum number on the status bar? The reason why is: I have two autofilters for two columns of data, and I beforehand highlight (select?) the third column of data (from the very top to the very bottom, with the autofilter on all, so nothing is hidden). I then change the value of the autofilter with a macro. I click on the continue button, and the macro changes the autofilter criteria again. I have a toggle breakpoint in the macro so I can pause and type the sum number from the status bar showing at the bottom of the window onto another workbook. I would like to not have to retype. I can write some code in the macro to put the value of the status bar into the destination workbook. Is there a variable or method that gets me the value of the sum number on the status bar? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How get sum value in status bar?
One way:
dSum = Application.Sum(Selection) In article , "Ian Elliott" wrote: Thanks for all help. Is there a variable or method that gets me the value of the sum number on the status bar? The reason why is: I have two autofilters for two columns of data, and I beforehand highlight (select?) the third column of data (from the very top to the very bottom, with the autofilter on all, so nothing is hidden). I then change the value of the autofilter with a macro. I click on the continue button, and the macro changes the autofilter criteria again. I have a toggle breakpoint in the macro so I can pause and type the sum number from the status bar showing at the bottom of the window onto another workbook. I would like to not have to retype. I can write some code in the macro to put the value of the status bar into the destination workbook. Is there a variable or method that gets me the value of the sum number on the status bar? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Status Bar | Excel Discussion (Misc queries) | |||
reuest formula for auto update status & status date | Excel Worksheet Functions | |||
Status Bar | Excel Discussion (Misc queries) | |||
What is EN on status bar? | Excel Discussion (Misc queries) | |||
Need a msg box that displays time status or loading status | Excel Programming |