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