Imagine a new worksheet and in the range B2:B6 you have the values 1
3 4 5. If you highlight this range, provided you have selected "SUM
from the right click menu on the statusbar, the result Sum = 25 appear
in the status bar.

So, in VBA, how do I capture that result!? I want to be able to selec
my range - Range("B2:B6").select - and then capture that sum of th
values within that range but I can't work out how to do it.

Yes I could loop through all the cells within the range building up th
calc but I must be able to use the status bar Auto Calculate featur
somehow....

Many thanks guys

Ba

--
Message posted from http://www.ExcelForum.com