Worksheet functions in forms

[duncansancho]

Hi All,
I hope someone out there can help! I am trying to use a worksheet function (VLookup in this case), in a form code.
I get an error 1004 and it shows my named range (Restrictions) as being "empty"!
What am I doing wrong please?

txtName = Application.WorksheetFunction.VLookup(txtNumber, Restrictions, 2)

Duncan

 

[combo]

You need a reference which VBA understands:

txtName = Application.WorksheetFunction.VLookup(txtNumber, [Restrictions], 2)
or
txtName = Application.WorksheetFunction.VLookup(txtNumber, Range("Restrictions&quot, 2)

combo

 

[duncansancho]

Thanks a million - it works great!!
Duncan