I'd try:

WRange.formular1c1 _
= "=" & "Ipbmatch(rc[-7]," _
& LURange.Address(ReferenceStyle:=xlR1C1, external:=True) & ")"

I removed the extra ()'s surrounding the LURange.address stuff. If that LURange
is a contiguous range, then I would think that you wouldn't need them.

If it's a discontiguous range, you'll want to put them back.

And remember if you're speaking R1C1 reference style, then all the stuff has to
use that reference style.



Kobayashi wrote:

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

--

Dave Peterson