| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
