It doesn't matter whether I use .formulaR1C1 or .value I just can't get
the below syntax right!!!

WRange.Value = "=" & "Ipbmatch(rc[-7]," & (LURange.Address) & ")"

Wrange is a predefined range of cells in one column
IPBMatch is UDF = Public Function IPBMatch(CellRef As Range, SrchVals
As Range) As String
LURange is, again, a predefined range.

I'm sure this is straightforward for somebody that knows what they are
doing but, unfortunately, clearly I don't!

Any help appreciated.

Regards,

Adrian


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