On 07/14/09 14:43, Gert Groenhoff wrote:
a user defined name of a cell range is unique on all sheets. but I can't
find a way to get this range from a different sheet. The only method I
know is getCellRangeByName(), but this works only with the correct
sheet. How can I get the range if I only know the name? Can anyone help?
You can get the named range object from the document's NamedRanges
collection, and if it refers to a cell range, get that range using the
getReferredCells method:
oRange = oDoc.NamedRanges.getByName("foo").ReferredCells
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
