Posted to microsoft.public.excel.programming

Charlotte E.[_3_] Charlotte E.[_3_] is offline

external usenet poster

Posts: 160

VLookup a named range

I have a named range on a worksheet, called 'TableRange'.

Making a vlookup in a worksheet formula will be like this
=VLOOKUP(F17,TableRange,2,1)

How to do this in VBA???

D = Application.Vlookup(cVal,"TableRange",2,1)
....doesn't work :-(

TIA

CE

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
using a dynamic named range in a VLOOKUP	Dave F	Excel Discussion (Misc queries)	3	January 19th 07 08:38 PM
Vlookup in a named range	tuph	Excel Worksheet Functions	7	May 29th 06 02:23 AM
Vlookup in large named range	KemS	Excel Worksheet Functions	3	November 23rd 05 06:14 PM
Using named range in vlookup	lasca	Excel Programming	1	September 2nd 05 03:16 PM
Vlookup on named range	kev	Excel Programming	1	September 23rd 04 12:23 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us