You probably mean to do this:
ActiveCell.Value = Application.WorksheetFunction.VLookup(Range("A5"). Value,
europe_usedinprint, 2, False)
--
- K Dales


"Larry Levinson" wrote:

ActiveCell.Value = Application.WorksheetFunction.VLookup(A5,
europe_usedinprint, 2, False)

results in `unable to get the vlookup property of the
worksheetfunction class'

I am sure the data being sought exists in all the places it should.

any suggestions where I might be able to fix?

thanks in advance.


Larry Levinson
Talking up to the vocal ...
LLevinson*Bloomberg.net
(remove the star etc ....)