Posted to microsoft.public.excel.programming

ALEX

external usenet poster

Posts: 493

Vlookup error

I'm using very simple Vlookup function that is working very well in a
spreadsheet but in VB it says unable to get Vlookup property in
WorksheetFunction class.

Set rngLogIn = Worksheets("Main").Range("A9")

varName = Application.WorksheetFunction.VLookup(rngLogIn, LoginName, 3, False)

Can anybody help?

Thanks

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
VLOOKUP error #NAME	bderek95	Excel Discussion (Misc queries)	2	May 20th 10 05:27 PM
Error in VLOOKUP	Kris	Excel Worksheet Functions	4	May 27th 09 09:51 PM
VLOOKUP error	Alfredo Martinez	Excel Discussion (Misc queries)	2	October 28th 08 04:46 AM
Vlookup Error	mick.smith1964	Excel Worksheet Functions	5	January 13th 05 10:03 PM
using vlookup, but error #N/A	ErinGertz	Excel Programming	6	December 18th 03 10:31 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us