but there still a problem with the SCOPE of the named range
I define all the data in the sheet2.
When I use XLSIO to define the named range, using the code posted before, the scope is set to sheet2
When I do directly inside Excel, the scope is set to workbook
(To view the scope of the Name Manager, under the Formulas menu)
So, how can I set the scope of a named range?