B BLOOD... Feb 17, 2004 #1 microsoft excel 2003 vlookup why macro source codes............... thanks...
T Tom Ogilvy Feb 17, 2004 #2 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.
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 Feb 17, 2004 #3 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. Click to expand...
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. Click to expand...
B Bob Phillips Feb 17, 2004 #4 I think any guess from that is totally left field. It was just a random bunch of words to me<g> Bob
