excellent thanks very much, just what i needed.........


"Norman Jones" wrote in message
...
Hi Jarvis,

As a starting point, see J.E. McGimpsey'a Accumulator
page at:


Using a Cell as an Accumulator
http://www.mcgimpsey.com/excel/accumulator.html



---
Regards,
Norman



"Jarvis" wrote in message
...
Hi
I have an excel sheet with an external link (say to cell B2). The value
in this cell can change at various times throughout the day. Is there a
piece of VBA I can put in to keep count of the sum total of values
throught the day in another cell please?

Many thanks for the help

J