Try the INDIRECT function. If the range is named MyFile, then something like:
=INDIRECT(MyFile&"WK1!h22")

Note that INDIRECT will always refer to H22 on the source worksheet, so if
you move H22, you need to change the formula.


"ds_shades" wrote:

I am using a cell name to simplify my formulas

inside the cell that I named I put the path to a filename.
c:\users\documents\[filename.xls]


I have an Issue that when I create a simple formula like this
=[Filename]WK1!h22 it works just fine I get a result

But when I create a complex formula I get an #ref error when I step through
the formula.

If I take the complex formula and just type in the file name it works just
fine. So I do not understand why I can not just use the cell name because it
is essentially the same thing.