Make sure calculation is set to automatic (I think) and then just add something
to the range (E6:E##).

wrote:

ok so its created it but do i have to do something for it to
autoupdate itself like an eventhandelr?

thanks

--

Dave Peterson