The status bar is just a display based on selection. You can get the same
thing with a helper cell and a little VBA. Let's use cell Z100 as the helper.

Sub qwerty()
Range("Z100").Value = Application.WorksheetFunction.Sum(Selection)
Range("Z100").Copy
End Sub

Select the cells. Run the macro. Go elsewhere. Do a paste.
--
Gary''s Student - gsnu200840


"MCook" wrote:

Can you copy the data from the Status Bar to another cell in the spread
sheet. Example, select SUM on the status bar, select a range of cells, status
bar shows the SUM, can that number be copied?
Thanks,