How get sum value in status bar?

[Guest]

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?

 

[JE McGimpsey]

One way:

dSum = Application.Sum(Selection)