Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi ,
I have a rather long formula which has been given a name. I need to edit it occasionally but when I choose INSERT - NAME - DEFINE and choose the "name" the formula appears in the refer box as expected. However only the first 63 characters can be edited. I cannot scroll along to the remaining characters. At the moment I am having to rewrite the formula again. Anyway around this without resorting to writing the formula into a cell rather than the defined name? Ken |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Define Names in Excel | Excel Discussion (Misc queries) | |||
Define a chart using VBA | Charts and Charting in Excel | |||
alternate UI for Define Names ?? | Excel Discussion (Misc queries) | |||
Define Name use in Macros | Excel Discussion (Misc queries) | |||
I can define a name, but I cannot use the name - menu Insert-Name-Use is blank | Excel Discussion (Misc queries) |