Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula fails to read name
Im experiencing some buggy behavior. It one of those it was working
and now it wont... From a data sheet and a template sheet, code creates a sheet of formulas that refer to many names ranges. For example one cell formula is =MAX(LmtIMP_1_kHz). When the sheets are created the cell displays #NAME? to fix the problem all I have to do is click into the cell and ENTER. What causes this and mor importantly what can I do to fix it. Thanks Rober |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula fails to read name
Maybe when you create the formula, you haven't yet defined the named range?
- Regards, Tom Ogilvy "Robert H" wrote: Im experiencing some buggy behavior. It one of those it was working and now it wont... From a data sheet and a template sheet, code creates a sheet of formulas that refer to many names ranges. For example one cell formula is =MAX(LmtIMP_1_kHz). When the sheets are created the cell displays #NAME? to fix the problem all I have to do is click into the cell and ENTER. What causes this and mor importantly what can I do to fix it. Thanks Rober |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula fails to read name
ahhhh, the Formulas and Names exist on the template but the names are
deleted and recreated when the new sheets are created. I bet I some how ran the code on the template sheet (should have reprotected it after the last edit) and it set the name creation to now have occured after the formulas were created. It shouldent be to painfull a recovery Thanks Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formula fails to update | Excel Discussion (Misc queries) | |||
TEXT-formula in VB Macro fails | Excel Programming | |||
cell.formula fails | Excel Programming | |||
VBA Formula Fails to Execute | Setting up and Configuration of Excel | |||
Row insert fails to update Sum formula | Excel Programming |