Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 -- 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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting to absolute reference
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" wrote in message news:T.De.Villiers.228ubn_1138281903.5455@excelfor um-nospam.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying a work sheet cell reference as relative not absolute? | Excel Discussion (Misc queries) | |||
Excel should have a absolute reference cell property. | Excel Discussion (Misc queries) | |||
Trouble with making a 3D reference absolute | Excel Discussion (Misc queries) | |||
Absolute Worksheet reference number | Excel Discussion (Misc queries) | |||
Unmovable absolute reference | Excel Worksheet Functions |