Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Name of named formula used in an INDIRECT function
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indirect equivalent for named arrays | Excel Worksheet Functions | |||
named range in sum formula (indirect, offset, worksheet name) | Excel Worksheet Functions | |||
Using Indirect with Named Ranges | Excel Worksheet Functions | |||
Indirect to Named range | Excel Worksheet Functions | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions |