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

Reply via email to