Posted to microsoft.public.excel.programming

Mike H.

external usenet poster

Posts: 471

Error 1004 in WorksheetFunction.VLookup

What could POSSIBLY be causing the error 1004 on this code:

Dim LookLU2 as Range
Dim Stats as Variant

Set LookLU2 = Workbooks("PRProc.xls").Names("StatsAcc").RefersTo Range
Stats = Application.WorksheetFunction.VLookup("112001", LookLU2, 2, False)

The file is open, the lookup works when I do it manually. I don't get it.
Any ideas?

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 error	Larry Levinson	Excel Programming	15	August 6th 05 12:41 AM
Worksheetfunction.vlookup and #value error	BL	Excel Worksheet Functions	2	June 17th 05 09:48 PM
Error '1004' in WorksheetFunction	oakman[_16_]	Excel Programming	0	November 18th 04 01:48 PM
Error '1004' in WorksheetFunction	oakman[_15_]	Excel Programming	1	November 17th 04 08:16 PM
Error '1004' in WorksheetFunction	oakman[_14_]	Excel Programming	1	November 17th 04 03:56 PM

All times are GMT +1. The time now is 12:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us