Stef,

Normally, you would use INDIRECT (based on your scant description of what you want to do) but
INDIRECT doesn't work with 3D ranges. Perhaps you could offer a better description, and we can come
up with a solution.

HTH,
Bernie
MS Excel MVP


"Stef" wrote in message
...
Does anyone have experience with 3D formulas in Excel. Specifically I would
like to chance a cell value and have the formula automatically pick up the
new end point to the 3D formula.