ExcelBanter - I need your help again

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - I need your help again (https://www.excelbanter.com/excel-programming/356708-i-need-your-help-again.html)

Prickle

I need your help again

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

Chip Pearson

I need your help again

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

Prickle

I need your help again

Thanks Chip
Once again you saved me a few tufts of hair

"Chip Pearson" wrote in message
...
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

All times are GMT +1. The time now is 12:38 AM.