Dave,

Thanks very much! I had to qualify the 'IPBmatch' function with it's
full address (it's in a different workbook) but as soon as I did it
worked a treat!

Clearly it's the '(ReferenceStyle:=xlR1C1, external:=True)' part that
makes this work and which I didn't know had to be included.

One last thing (I promise), I have 'Application.Calculation =
xlCalculationManual' early in my code but as soon as I enter the above
formula, that you helped me with, in the range it automatically starts
calculating?

Any ideas?

Many thanks indeed for your help. I'd have been here all week!


--
Kobayashi
------------------------------------------------------------------------
Kobayashi's Profile: http://www.excelforum.com/member.php...nfo&userid=871
View this thread: http://www.excelforum.com/showthread...hreadid=557868