<img src=/S/surrender.gif border=0 alt=surrender width=31 height=23> I have a range that extends from cell B2 to B5. It contains the values 1 through 4. I assigned the range name Bob to that range.
I add some more values, 5 through 9, at the bottom, from cell B6 through B10. I want to include these new cells in the range name Bob.
If I select the new range, and then I go to Insert Name Define, I can reenter Bob and I get the new range, covering from B2 to B10. This is cumbersome. If I make the slightest mistake, Bub, in that range name, it still works, but all my references to the range name Bob still refer to Bob and not to Bub.
Is there better way to enlarge a range name? Ideally, I would like to select the new range of cells and then select the range name, which would assign the new range to that range name.