Thanks, but not really very helpful. How did you test it?

I realise that the UDF works in 2007 when used to reference a cell into which data or a formula has been entered manually or pasted manually.
However, the problem I have is that it fails when the pasting is executed by VBA code.

Any suggestions?

Peter Ross