ExcelBanter - Excel XML Spreadsheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Excel XML Spreadsheet (https://www.excelbanter.com/excel-programming/277215-re-excel-xml-spreadsheet.html)

Jim Rech

Excel XML Spreadsheet

What would the dynamic name key off of? Here a name starts at A1 and
extends a variable number of rows depending on the number of entries in the
range A1:A10:

<NamedRange ss:Name="DynName"
ss:RefersTo="=OFFSET(Sheet1!R1C1,0,0,COUNT(Sheet1! R1C1:R10C1),1)"/

--
Jim Rech
Excel MVP

All times are GMT +1. The time now is 05:41 PM.