copy temp sum in bottom right of excel to clipboard

Does anyone know how to take the value of the little window on the bottom
right of excel (ie you highlight a group of numbers and it shows the sum or
avg or whatever you choose.) and copy it to the clipboard?

Cheers!

Anyone want to take a crack at this?

"Job" <Job@nomail.com> wrote in message
news:elGxRfvCFHA.2156@TK2MSFTNGP10.phx.gbl...
> Does anyone know how to take the value of the little window on the bottom
> right of excel (ie you highlight a group of numbers and it shows the sum
> or avg or whatever you choose.) and copy it to the clipboard?
>
> Cheers!
>

I don't think I could get to that statusbar to retrieve the value, but maybe a
macro.

Option Explicit
Sub testme()

Dim MyDataObj As DataObject
Dim myVal As Variant

Set MyDataObj = New DataObject

myVal = Application.Sum(Selection)
MyDataObj.SetText myVal
MyDataObj.PutInClipboard

End Sub

You'll want to read Chip Pearson's notes on working with the clipboard:
http://www.cpearson.com/excel/clipboar.htm

Especially:
Because these procedures use the DataObject variable type, you must have a
reference set in your VBA project to the Microsoft Forms 2.0 object library.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Job wrote:
>
> Does anyone know how to take the value of the little window on the bottom
> right of excel (ie you highlight a group of numbers and it shows the sum or
> avg or whatever you choose.) and copy it to the clipboard?
>
> Cheers!

--

Dave Peterson