Docs: SpeedGen: Using Named Ranges (Defined Names)

A Named Range is useful Excel feature that enables you to assign a name to any group of cells (Range).

Example: you can simply use sum(SalesData) instead of sum(A2:A105)

Web Link

• Creating and using Named Ranges in Microsoft Excel

If your Named Range for a Multi-Row Field Marker refers to a single cell that contains a Field Marker then you must change it to a Mirror Range

Example

You assign the name SalesData to the Field Marker in Cell A1

You open the Defined Name Dialog (Excel Menu: Insert | Name | Define) and notice that it is a Cell Reference, not a Range.

Because it is a Cell Reference, SpeedGen will not Stretch it over the Inserted Data. So you need to change it to Sheet1!$A$1:$A$1 (the $ is optional). This tells SpeedGen that the Range can be Stretched.