I am making a function which involves a LOOKUP, but I am trying to take
all the formulas out of the cells by putting them as names. Is it
possible to replace a list in an array of cells with a single name?
Eg, if I have =LOOKUP(input,check_list,output)
I can make check_list and output refer to a range, but not connected to
cells in the worksheet.
Also, does anyone know of a good link for a comprehensive tutorial with
VBA custom functions. I've seen the one on this site, and although
it's useful it doesn't go very far...
Thanks,
Tony
------------------------------------------------
~~ Message posted from
http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/