Just one more question Per
With this code how do I include if the cell is empty then show zero?
--
Tdp


"Tdp" wrote:

Thanks Per that seems to work fine
Many thanks
--
Tdp


"Per Jessen" wrote:

Try this:

x = Application.WorksheetFunction.VLookup(Range("AZ4") , Sheet3.Range("A:B"),
2, 0)

Regards,
Per

"Tdp" skrev i meddelelsen
...
How do I change the following as a vb code???
=VLOOKUP(AZ4,Sheet3!A:B,2,0)
--
Tdp