How get sum value in status bar?

[Ian Elliott]

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)

In article <97361D0B-717F-4725-B5DA-0E00B8A4FC4D@microsoft.com>,
"Ian Elliott" <IanElliott@discussions.microsoft.com> 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?