You're welcome Sharkfoot,

"sharkfoot" wrote
in message ...

Thank you so much. This works perfectly. And the way you explain things
helps me learn much better than someone just fixing the problem for me.

"Sandy Mann" wrote in message
...

H & L and all three tables updated as expected. I found by
experimentation
that the .Calculate line that was in my original code was not required -
Excel calculates when the formulas are pasted in

Seems like we both learned for the experience.

--
Regards

Sandy

with @tiscali.co.uk