"ShiftPattern_1" looks like this:
"=IF(AND(ISTEXT(ProdCal.Data!O2),ISERROR(SEARCH("B ridge*",ProdCal.Data!
O2,1))),0,IF(WEEKDAY(ProdCal.Data!L2,2)=PM_Day_7,S hiftsOnPMDay,3))

ShiftPattern_1 has to resolve to a *text representation of a valid
reference*. The above formula doesn't meet that requirement.


--
Biff
Microsoft Excel MVP


"Werner Rohrmoser" wrote in message
...
Hello,

I searched this group for an answer, but I couldn't find it.
I would like to use the name of a named formula in the INDIRECT
function,
so I can change the used formula by changing the referenced cell.
For example in Range("A1") I will write the name of the named formula
like "ShiftPattern_1", "ShiftPattern_2" or "ShiftPattern_3".
In the cells, where the formulas are used I'd like to use something
like
"INDIRECT("A1") in order to use the formula which I have put in
Range("A1").
The formula behind the name "ShiftPattern_1" looks like this:
"=IF(AND(ISTEXT(ProdCal.Data!O2),ISERROR(SEARCH("B ridge*",ProdCal.Data!
O2,1))),0,IF(WEEKDAY(ProdCal.Data!L2,2)=PM_Day_7,S hiftsOnPMDay,3))
Some standard formulas and some named ranges like "PM_Day_7" or
"ShiftsOnPMDay".

I hope I've described my problem good enough to get an answer whether
it's possible or not.
Thanks.

Excel XP SP3
WIN XP SP3