hello :)

T

Tom Ogilvy

set rng = Worksheets("Sheet3").Range("A1").CurrentRegion

res = Application.Vlookup("abcd",rng,3,false)

if not iserror(res) then
msgbox res
End if

is as good a guess as any.
 
S

Stephan Kassanke

ROTFL =)

Tom Ogilvy said:
set rng = Worksheets("Sheet3").Range("A1").CurrentRegion

res = Application.Vlookup("abcd",rng,3,false)

if not iserror(res) then
msgbox res
End if

is as good a guess as any.
 
B

Bob Phillips

I think any guess from that is totally left field. It was just a random
bunch of words to me<g>

Bob
 
Top