How to reassign the address of a named range in Open Office VBA?

In Excel VBA, I redefine the address of a named range with:

Ranges("MyRange").Cells(1).CurrentRegion.Name = "MyRange"

in the Worksheet_Deactivate event.

This way, after updating the spreadsheet, MyDataRange always references to the entire data. Ok with Excel, but when I tried to migrate this to Open Office VBA ( 3.1.1 / OOO310m19 Build:9420) the ".Name" property of the Range isn't defined.

Then, I tried with:

ThisWorkbook.Names("MyDataRange").RefersTo = Range("MyDataRange").Cells(1).CurrentRegion

with no luck ("the property is Read Only" error)

Again, I tried with:

ThisWorkbook.Names.Add ("MyDataRange", Range("MyDataRange").Cells(1).CurrentRegion)

This works, but after that all the cells with validations that references to the named range loses the original reference and shows "#NAME#" in the popup.

Is there any way to reassign the address of a named range without losing the references to it?




I wonder if this technique would work?

Need Your Help

How do I search for names starting wih A in MySQL?

sql mysql database

I have a question that how can we use SELECT for searching the name which start with 'A' in MySQL table?

How to display a “Loading…” message that closes automatically when processing is over (similar to Progress Bar)?

java swing jframe jlabel actionlistener

I have a comboBox jComboBox1 that contains names of all countries in the world...Upon selection of one of the countries a second combobox jComboBox2 is populated with all the states in the country

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.