View Single Post
  #5   Report Post  
Vasant Nanavati
 
Posts: n/a
Default

For example:

WorksheetFunction.VLookup(Range("A1"), Range("B1:D100"), 4, False)

--

Vasant

"Steve Haack" wrote in message
...
I would like to be able to call some of the excel built-in functions
(specfically VLOOKUP) in some code. Can someone point me to an example of

how
to do this?

Thanks,
Steve