3-D Referencing ?

[mhenk]

I have created a named range that is a 3-D reference. Does anyone know if it is possible to access a piece of the information by using an index function or something. For example, the named range "Data" represents a single cell on every sheet from Sheet1:Sheet47. Is it possible to find the information from that particular cell on Sheet8 by using a function?

 

[babycody]

See if the threed UDF from MOREFUNC addin is what you are looking for. HTH! http://xcell05.free.fr/english/