PDA

View Full Version : Solved: Store Application.Vlookup Value in Array?



bopo
01-26-2007, 04:22 PM
Hi

I tried to store a value into an array from v.lookup which brings back a number, however on the userform, I get 'Sub or function not defined' any ideas?

Bob Phillips
01-26-2007, 05:51 PM
VLOOKUP only returns a singlevalue, so why do you need an array?

Post the code that isn't working with a better descriptin of the problem.

bopo
01-27-2007, 03:24 AM
Its okay, I got it