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!

copy temp sum in bottom right of excel to clipboard
 

Anyone want to take a crack at this?

"Job" wrote in message
...
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!

copy temp sum in bottom right of excel to clipboard
 

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