| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel I want to copy text from spreadsheet to spreadsheet | Excel Worksheet Functions | |||
| convert ms works spreadsheet to excel spreadsheet on pda | Excel Discussion (Misc queries) | |||
| conversion of MS Works Spreadsheet to Excel 2002 Spreadsheet | Excel Discussion (Misc queries) | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
| How to open another Excel spreadsheet to copy data into current spreadsheet ? | Excel Programming | |||
Hybrid Mode
