Converting to absolute reference

Hi, I need to ensure that if the user enters a lookup range with relative references, it is converted to absolute.
Below,ive tried using xlabsolute(b), but its not quite working, any help
is much appreciated

Function taz(a, b, c)

On Error Resume Next
taz = WorksheetFunction.VLookup(a, xlabsolute(b), c, 0)


On Error GoTo 0
If IsError(taz) Then
taz = 0
End If
End Function

All you can do is use an absolute version of the range provided, which is
totally pointless. Why do you want to do this?

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"T De Villiers" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi, I need to ensure that if the user enters a lookup range with
> relative references, it is converted to absolute.
> Below,ive tried using xlabsolute(b), but its not quite working, any
> help
> is much appreciated
>
> Function taz(a, b, c)
>
> On Error Resume Next
> taz = WorksheetFunction.VLookup(a, xlabsolute(b), c, 0)
>
>
> On Error GoTo 0
> If IsError(taz) Then
> taz = 0
> End If
> End Function
>
>
> --
> T De Villiers
> ------------------------------------------------------------------------
> T De Villiers's Profile:
http://www.excelforum.com/member.php...o&userid=26479
> View this thread: http://www.excelforum.com/showthread...hreadid=505296
>