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/