how get value of status bar sum?
 

Thanks for all help.
I need to put the value of the status bar sum into a variable. How do I
access the status bar sum value?
Someone said use Dsum=application.sum(selection), but I need the value in
the status bar, not what is selected (I am using autofilter).
Thanks.

how get value of status bar sum?
 

Hi Ian,

Try:

Sub Tester03()
Dim dSum As Double

dSum = Application.Sum( _
Selection.SpecialCells(xlVisible))

MsgBox dSum

End Sub


---
Regards,
Norman



"Ian Elliott" wrote in message
...
Thanks for all help.
I need to put the value of the status bar sum into a variable. How do I
access the status bar sum value?
Someone said use Dsum=application.sum(selection), but I need the value in
the status bar, not what is selected (I am using autofilter).
Thanks.

how get value of status bar sum?
 

But the sum in the status bar will be what is selected!

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ian Elliott" wrote in message
...
Thanks for all help.
I need to put the value of the status bar sum into a variable. How do I
access the status bar sum value?
Someone said use Dsum=application.sum(selection), but I need the value in
the status bar, not what is selected (I am using autofilter).
Thanks.