Copy Excel 2003 "status bar" sum to cell?
 

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

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

Copy Excel 2003 "status bar" sum to cell?
 

Perfect!! Thanks for your help Chip!

Dennis
"Chip Pearson" wrote in message
...
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