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!
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks