Thread: Copy Excel 2003 "status bar" sum to cell?
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 Copy Excel 2003 "status bar" sum to cell?
Dennis,

The status bar sums the selection, so you could use code like

Range("A1").Value = Application.Sum(Selection)


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


"Dennis Shannon" wrote in message
...
Is there a way to have Excel automatically update a cell with
the sum total that is displayed in the status bar?

Thanks,
Dennis Shannon



Reply With QuoteReply With Quote