WORKSHEET FUNCTION 1

[ASAFP]

Hi,
I'm trying to activate a worksheet function in vba
I used the following code:
x=application.worksheetfunction.vlookup(cells(i,7).value,range(Products"),3,true).
(I have a range with the name products)
I'm getting the error massege:
1004
Unable to get the vlookup property of the worksheetfunction class.

Any suggestions?

Thanks!

 

[Loomah]

Hi
Just a quick thought - is there a conflict between the data type you are looking up (ie the val in cells(i,7)) and the type of data in column 1 of "Products"?

;-)

If a man says something and there are no women there to hear him, is he still wrong?
The faqs ma'am, just the faqs. Get the best from these forums : faq222-2244

 

[ASAFP]

Thanks a lot!
It seems like this was the problem