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