Textbox2=WorksheetFunction.Vlookup(Textbox1,Range( "NamedRange"),2,False)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Prickle" <prick@somewherecom wrote in message
...
Can someone please suplly me with the syntax for using a named
range in a WorksheetFuntion statement

e.g

Textbox2=WorksheetFunction.Vlookup(Textbox1,NamedR ange,2,False)

I am having difficulty expressing the NamedRange correctly

Regards & TIA