Making arrays outside cells

T

tclohesy

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
 
T

Tom Ogilvy

Range and cells in the worksheet are equivalent. It is unclear what you
are asking.

You can put formulas in defined names, but it is pretty hard to work with,
so I don't think I would do it until I knew all my formulas were in their
final form.

There isn't a whole lot of mystery to User defined functions. A
comprehensive tutorial would be about two or three paragraphs.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell values to an array, then array transpose to another workbook 8
CSE with function returning an array? 2
Array takes 6x longer to process VLOOKUP than worksheet table does 3
Cells range into an array, then into msgbox 7
Array VLOOKUPs take 6 times longer than worksheet range VLOOKUPs 2
Need to embed a graphic, then make a call to it 9
Arrays 3
Vlookup formula entered by VBA, returns from another worksheet 3

Top