I like this style:
dim res as variant 'could return an error.
res = application.vlookup(worksheets("sheet1").range("a1 ").value, _
worksheets("sheet2").range("a:b"), 2, false)
if iserror(res) then
'it would have returned an #n/a error on the worksheet
msgbox "N/A"
else
msgbox res
end if
By using the application.vlookup() syntax, I get a result that can be tested
later.
Steve Haack wrote:
I would like to be able to call some of the excel built-in functions
(specfically VLOOKUP) in some code. Can someone point me to an example of how
to do this?
Thanks,
Steve
--
Dave Peterson
|