Status Bar sum value copy to spreadsheet
 

When I select a range of cells on my sheet I see the SUM in the status bar.
Is there any way to transfer that sum into my spreadsheet (eg Paste) rather
than writing a formula explicitly?
Thanks

Status Bar sum value copy to spreadsheet
 

Say we use cell A1 and we want A1 to reflect the sum of the selected cells.
Insert the following worksheet event macro:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A1").Value = Application.Sum(Target)
End Sub


Because it is worksheet code, it is very easy to install and automatic to use:

1. right-click the tab name near the bottom of the Excel window
2. select View Code - this brings up a VBE window
3. paste the stuff in and close the VBE window

If you have any concerns, first try it on a trial worksheet.

If you save the workbook, the macro will be saved with it.


To remove the macro:

1. bring up the VBE windows as above
2. clear the code out
3. close the VBE window

To learn more about macros in general, see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

To learn more about Event Macros (worksheet code), see:

http://www.mvps.org/dmcritchie/excel/event.htm

--
Gary''s Student - gsnu200800


"Rudi" wrote:

When I select a range of cells on my sheet I see the SUM in the status bar.
Is there any way to transfer that sum into my spreadsheet (eg Paste) rather
than writing a formula explicitly?
Thanks

Status Bar sum value copy to spreadsheet
 

Excellent solution. Thanks. Rudi

"Gary''s Student" wrote:

Say we use cell A1 and we want A1 to reflect the sum of the selected cells.
Insert the following worksheet event macro:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A1").Value = Application.Sum(Target)
End Sub


Because it is worksheet code, it is very easy to install and automatic to use:

1. right-click the tab name near the bottom of the Excel window
2. select View Code - this brings up a VBE window
3. paste the stuff in and close the VBE window

If you have any concerns, first try it on a trial worksheet.

If you save the workbook, the macro will be saved with it.


To remove the macro:

1. bring up the VBE windows as above
2. clear the code out
3. close the VBE window

To learn more about macros in general, see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

To learn more about Event Macros (worksheet code), see:

http://www.mvps.org/dmcritchie/excel/event.htm

--
Gary''s Student - gsnu200800


"Rudi" wrote:

When I select a range of cells on my sheet I see the SUM in the status bar.
Is there any way to transfer that sum into my spreadsheet (eg Paste) rather
than writing a formula explicitly?
Thanks

Status Bar sum value copy to spreadsheet
 

You are very welcome!
--
Gary''s Student - gsnu200800


"Rudi" wrote:

Excellent solution. Thanks. Rudi

"Gary''s Student" wrote:

Say we use cell A1 and we want A1 to reflect the sum of the selected cells.
Insert the following worksheet event macro:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A1").Value = Application.Sum(Target)
End Sub


Because it is worksheet code, it is very easy to install and automatic to use:

1. right-click the tab name near the bottom of the Excel window
2. select View Code - this brings up a VBE window
3. paste the stuff in and close the VBE window

If you have any concerns, first try it on a trial worksheet.

If you save the workbook, the macro will be saved with it.


To remove the macro:

1. bring up the VBE windows as above
2. clear the code out
3. close the VBE window

To learn more about macros in general, see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

To learn more about Event Macros (worksheet code), see:

http://www.mvps.org/dmcritchie/excel/event.htm

--
Gary''s Student - gsnu200800


"Rudi" wrote:

When I select a range of cells on my sheet I see the SUM in the status bar.
Is there any way to transfer that sum into my spreadsheet (eg Paste) rather
than writing a formula explicitly?
Thanks