You ROCK!!!! I just finished reviewing the entire list of functions and
never compehended what this one did.
Thank you very much.
"JBeaucaire" wrote:
This function is called INDIRECT, it lets you build up a cell reference
a piece at a time and concatenate them together piecemeal.
*='[File1.xls]Eastside'!D10
*
If the filename is in A10 and Tabname is in B10 and the cell reference
is in C10, the INDIRECT formula would be:
*
=INDIRECT("'["&A10&"]"&B10&"'!"&C10)
*Or, you can leave out the reference to C10 and encode the rest
directly into the formula:
*=INDIRECT("'["&A10&"]"&B10&"'!D10")*
--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=45178