| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| EXCEL allow 2 options on status bar e.g. show "Count" + "Sum" | Excel Discussion (Misc queries) | |||
| Excel 2003 - Save As function inserts "Copy of" | Excel Discussion (Misc queries) | |||
| Excel 2003 VBA - "Maximizing" Window & "Calculating" Workbook | Excel Programming | |||
Threaded Mode
