software

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 quot;namequot; 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
Ken this is going to sound a bit weird

Highlight it with your mouse. Doing this allows it to slide back and forth
across the formula. Once you're in the area you have to edit click to
unhighlight and edit the portion you need to.

Sounds weird. But when weird works who's gonna argue?
quot;Ken Johnstonquot; wrote:

gt; Hi ,
gt;
gt; I have a rather long formula which has been given a name.
gt;
gt; I need to edit it occasionally but when I choose INSERT - NAME - DEFINE and
gt; choose the quot;namequot; the formula appears in the refer box as expected. However
gt; only the first 63 characters can be edited. I cannot scroll along to the
gt; remaining characters. At the moment I am having to rewrite the formula
gt; again.
gt;
gt; Anyway around this without resorting to writing the formula into a cell
gt; rather than the defined name?
gt;
gt; Ken
gt;
gt;
gt;

Click in the quot;Refers Toquot; box, then hit lt;F2gt;.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;Ken Johnstonquot; gt; wrote in message
...
gt; Hi ,
gt;
gt; I have a rather long formula which has been given a name.
gt;
gt; I need to edit it occasionally but when I choose INSERT - NAME - DEFINE
and
gt; choose the quot;namequot; the formula appears in the refer box as expected.
However
gt; only the first 63 characters can be edited. I cannot scroll along to the
gt; remaining characters. At the moment I am having to rewrite the formula
gt; again.
gt;
gt; Anyway around this without resorting to writing the formula into a cell
gt; rather than the defined name?
gt;
gt; Ken
gt;
gt;gt; Click in the quot;Refers Toquot; box, then hit lt;F2gt;.

Make sure you hit that F2 key before you start navigating with your
directional arrow keys!

If not, you'll be cussing!

Biff

quot;Ragdyerquot; gt; wrote in message
...
gt; Click in the quot;Refers Toquot; box, then hit lt;F2gt;.
gt;
gt; --
gt; HTH,
gt;
gt; RD
gt;
gt; ---------------------------------------------------------------------------
gt; Please keep all correspondence within the NewsGroup, so all may benefit !
gt; ---------------------------------------------------------------------------
gt; quot;Ken Johnstonquot; gt; wrote in message
gt; ...
gt;gt; Hi ,
gt;gt;
gt;gt; I have a rather long formula which has been given a name.
gt;gt;
gt;gt; I need to edit it occasionally but when I choose INSERT - NAME - DEFINE
gt; and
gt;gt; choose the quot;namequot; the formula appears in the refer box as expected.
gt; However
gt;gt; only the first 63 characters can be edited. I cannot scroll along to the
gt;gt; remaining characters. At the moment I am having to rewrite the formula
gt;gt; again.
gt;gt;
gt;gt; Anyway around this without resorting to writing the formula into a cell
gt;gt; rather than the defined name?
gt;gt;
gt;gt; Ken
gt;gt;
gt;gt;
gt;
Very true lt;bggt;

If it is a long formula, then I often do the editing in a cell, where it
is easier to see the whole formula at once.
Once the formula is set as required, Copy and Paste into the quot;Refers Toquot;
box.
You won't have an option to Paste from the right click menu, but typing
Ctrl V to paste will work.

--
Regards

Roger Govierquot;Biffquot; gt; wrote in message
...
gt;gt; Click in the quot;Refers Toquot; box, then hit lt;F2gt;.
gt;
gt; Make sure you hit that F2 key before you start navigating with your
gt; directional arrow keys!
gt;
gt; If not, you'll be cussing!
gt;
gt; Biff
gt;
gt; quot;Ragdyerquot; gt; wrote in message
gt; ...
gt;gt; Click in the quot;Refers Toquot; box, then hit lt;F2gt;.
gt;gt;
gt;gt; --
gt;gt; HTH,
gt;gt;
gt;gt; RD
gt;gt;
gt;gt; ---------------------------------------------------------------------------
gt;gt; Please keep all correspondence within the NewsGroup, so all may
gt;gt; benefit !
gt;gt; ---------------------------------------------------------------------------
gt;gt; quot;Ken Johnstonquot; gt; wrote in message
gt;gt; ...
gt;gt;gt; Hi ,
gt;gt;gt;
gt;gt;gt; I have a rather long formula which has been given a name.
gt;gt;gt;
gt;gt;gt; I need to edit it occasionally but when I choose INSERT - NAME -
gt;gt;gt; DEFINE
gt;gt; and
gt;gt;gt; choose the quot;namequot; the formula appears in the refer box as expected.
gt;gt; However
gt;gt;gt; only the first 63 characters can be edited. I cannot scroll along to
gt;gt;gt; the
gt;gt;gt; remaining characters. At the moment I am having to rewrite the
gt;gt;gt; formula
gt;gt;gt; again.
gt;gt;gt;
gt;gt;gt; Anyway around this without resorting to writing the formula into a
gt;gt;gt; cell
gt;gt;gt; rather than the defined name?
gt;gt;gt;
gt;gt;gt; Ken
gt;gt;gt;
gt;gt;gt;
gt;gt;
gt;
gt;
Hi Ken,

if you use Name Manager (developed by myself and Jan Karel Pieterse) you can
see and edit all the characters in the name formula (as long as there are
less than about 256 characters).

download from
www.DecisionModels.com/downloads.htm

Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com

quot;Ken Johnstonquot; gt; wrote in message
...
gt; Hi ,
gt;
gt; I have a rather long formula which has been given a name.
gt;
gt; I need to edit it occasionally but when I choose INSERT - NAME - DEFINE
gt; and
gt; choose the quot;namequot; the formula appears in the refer box as expected.
gt; However
gt; only the first 63 characters can be edited. I cannot scroll along to the
gt; remaining characters. At the moment I am having to rewrite the formula
gt; again.
gt;
gt; Anyway around this without resorting to writing the formula into a cell
gt; rather than the defined name?
gt;
gt; Ken
gt;
gt;
Thanks to all who replied. A wonderful and helpful group.

Ken