Michael wrote:
Hi Alistair. This article written by Frank Kabel & Bob Phillips may help.
You could possibly paste the code into your macro:
http://www.xldynamic.com/source/xld.LastValue.html
HTH
Thanks for the link.

I will give it a go and see how I do.

ALi