How to obtain cell address of a succesful VLookup?
Thanks Aiden and especially, Tom
Tom Ogilvy wrote:
Dim res as Variant, rng as Range
res = Application.Match(Range("J68").Value, _
Worksheets("1000").Range("J139:J150"),0)
if not iserror(res) then
set rng = Worksheets("1000").Range("J139:J150")(res)
else
set rng = Nothing
end if
|