vlookup
 

how do i use the vlookup formula in vba?

vlookup
 

Use Application.WorksheetFunction.Vlookup()

The usual Vlookup arguments go in the brackets.

hth
big t


"new_to_vba" wrote:

how do i use the vlookup formula in vba?

vlookup
 

thanks for that big t, i actually saw the other posts after i posted mine.
got some sample code from them as well. you are all a great help thank you
all very much.

"big t" wrote:

Use Application.WorksheetFunction.Vlookup()

The usual Vlookup arguments go in the brackets.

hth
big t


"new_to_vba" wrote:

how do i use the vlookup formula in vba?