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