Hi Biff,
Thanks for that I'll try it out on a reasonable sized range to see how
fast it is compared with my monster, which is quite slow on my old
iMac.
Also, thanks for clearing up the bit about using an array formula in
the Refers to: box, that's something I didn't know (one of the many
things I don't know:-\).

Ken Johnson