If you have a range (column or row) of numbers and you hilite them, Excel displays the total (sum) of the hilited numbers in the lower right side of the screen. How do you, can you, paste that sum into a cell on the open sheet or another sheet? Does it take a little vba program to do that?
Thanks for your help.
Last edited by napadude; 12-01-2009 at 01:51 PM.
Yes, VBA is your best bet, eg:
so you would select your cells, run the above routine and the total would appear in Sheet1!A1
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
thank you for the help. I am not real good with VBA, but understand your sol'n.
I will look another place to find out how to implement the VBA.
What if I wanted to paste it to a cell that I had hilited on a sheet (any sheet that I happened to pick), how would I change the code - should have been more specific the 1st time around.
Again, thank you.
your "selection" is either
a) the values to sum
b) the cell in which to paste result
as a general rule it can't be both unless you come up with some logic to ensure say the first cell selected is always to contain the total and to be excluded from the calculation itself, ie:
but it's not very practical (obviously)Please Login or Register to view this content.
Thank you for the help, I understand.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks