- Jun 13, 2005
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?