View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default what is this object called? - right hand corner of statusbar

Squid,

I don't believe there is any way to retrieve that value.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Squid" wrote in message
news:LzLXb.41526$uV3.71986@attbi_s51...
In the bottom right hand corner of the status bar (right

click). A user has
the ability to either Average, Count, Count Nums, Max, Min or

Sum the
contents of the highlighted range. I want to be able to call

that procedure
using an OnKey Method to copy that value to the clipboard.

Then the user
could paste that value elsewhere in excel.