I have some named ranges that are formulas. I need to edit the
formula. I go to InsertNameDefine and select the Named Range whose
formula I want to edit. The formula appears in the Refers To box.
Here's the problem. The box is not large enough to show the entire
formula. Of course if I try to use any of the navigation keys in that
box (Home, End, Arrows, etc.), it starts changing the formula. I tried
copying the formula to a worksheet, editing the formula, then copying
it back and saying Add. Does not work. So I have to meticulously cut
into the formula, find where I want to edit, make the edit, then fix
all of the stuff that got messed up when I was editing.

I must be missing the easier way!

tod

when you select in the Refersto box hit F2 and you will be able to move with
the arrow keys.
--
Regards,
Tom Ogilvy

tod wrote in message
m...
I have some named ranges that are formulas. I need to edit the
formula. I go to InsertNameDefine and select the Named Range whose
formula I want to edit. The formula appears in the Refers To box.
Here's the problem. The box is not large enough to show the entire
formula. Of course if I try to use any of the navigation keys in that
box (Home, End, Arrows, etc.), it starts changing the formula. I tried
copying the formula to a worksheet, editing the formula, then copying
it back and saying Add. Does not work. So I have to meticulously cut
into the formula, find where I want to edit, make the edit, then fix
all of the stuff that got messed up when I was editing.

I must be missing the easier way!

tod