T

#### tod

formula. I go to Insert>Name>Define 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