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