Posted to microsoft.public.excel.programming

Ben

external usenet poster

Posts: 509

vlookup worksheetfunction

What is the proper syntax for using

application.worksheetfunction.vlookup(emb,"c:\list s\filename.xls"!sheet1.A1:AB300,5,false)

Basically how do you use the worksheetfunction vlookup looking up in a
different file, with the full path in case the file is not open

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
WorksheetFunction.Vlookup	leerem	Excel Discussion (Misc queries)	8	October 25th 08 07:58 PM
Worksheetfunction.vlookup and #value error	BL	Excel Worksheet Functions	2	June 17th 05 09:48 PM
application.worksheetfunction.vlookup	JulieD	Excel Programming	5	August 12th 04 04:42 PM
Unable to get the Vlookup Property of the WorkSheetFunction Class	monagan	Excel Programming	2	August 3rd 04 09:32 PM
worksheetfunction.vlookup?	devnext	Excel Programming	1	October 29th 03 06:41 PM

All times are GMT +1. The time now is 06:04 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us