At 17:17 21/03/2019 -0400, Vince Bonly wrote:
On 3/19/2019 10:00 PM, Brian Barker wrote:
To modify the definition of a name:
o Go to Insert | Names > | Define... .
o Select the existing name.
o Drag across the new range.
o Modify.
o OK.
Just to let you know that your suggestions / instructions worked out
splendidly here, and to say TNX again. Certainly was helpful.
Good-oh! No probs!
I do wish, however, that there was a "More" or "Continue" button
available, rather than needing to go back to step one. I had to
change the Named Ranges for 13 columns that were shifted in the spreadsheet.
That's easy, and there is no need for an extra button: just repeat
steps two, three, and four - Select, Drag, and Modify - as necessary,
before using OK once.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org