Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UDF not working for VLookup
I am trying to write a UDF but it does not work.
Here is my simple code, what am I doing wrong? =================== Public Function PP(rng) Dim WB As Workbook Set WB = Workbooks("Code Master.xls") MsgBox WB.Sheets(1).Range("A10").Value Set VLRNG = WB.Sheets("SHEET1").Range("B:K") 'PP = Application.WorksheetFunction.VLookup(rng.Value, VLRNG, 4, 0) '<<<not working PP = Evaluate(Application.WorksheetFunction.VLookup(rng , VLRNG, 4, 0))'<<<not working End Function ================== Pl help. Regards, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Not working | Excel Worksheet Functions | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
VLOOKUP NOT WORKING | Excel Discussion (Misc queries) | |||
Vlookup no working | New Users to Excel | |||
Vlookup still not working | Excel Programming |