Posted to microsoft.public.excel.programming

Damien McBain[_2_] Damien McBain[_2_] is offline

external usenet poster

Posts: 49

What's wrong with this?

LevBR = Application.WorksheetFunction.VLookup(daDate, Range("A5:A35"), 1,
False)

where LevBR is a declared variable
and daDate is a declared (as Range) variable which has been set
(with Set daDate = Worksheets("Main").Range("date"))

I get the "Unable to get the VLookup property of the WorksheetFunction
class" error

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
What am I doing wrong	aussiegirlone	Excel Discussion (Misc queries)	15	July 18th 09 10:08 AM
What is wrong with my UDF	jlclyde	Excel Discussion (Misc queries)	4	October 24th 08 03:06 PM
Insert Calculated Field (wrong Qty*Price = wrong Amount)	Edmund	Excel Discussion (Misc queries)	8	October 4th 07 12:13 PM
Getting wrong value due to ref?	jesmin	Excel Discussion (Misc queries)	2	March 16th 06 02:12 AM
Am I doing something wrong here?	TyeJae[_21_]	Excel Programming	2	June 29th 04 12:56 AM

All times are GMT +1. The time now is 03:13 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us