Cell Ranges are used throughout Excel, but mainly in Formulas and Charts. Usually SpeedGen automatically adjusts all ranges to fit your inserted data. This feature is called Stretching and can be controlled by the Stretch property.
Excel Cell Ranges look like: A1 or A1:B1 or Sheet2!G3:K7
Important! Sometimes you need to use Mirror Ranges
A Mirror Range is a way to tell SpeedGen that you want to stretch a row to accommodate the inserted data. A Mirror Range looks like A1:A1 or C5:C5
- A Mirror Range is only required when you want to stretch a reference to a cell containing a Multi-Row Field Marker
- If your range already uses multiple rows, like =sum(A1:A2) then you do not need to use Mirror Ranges.
- A Mirror Range will not Stretch if the Stretch Property is False.
Examples
Let's say you want to calculate the sum of all Data Inserted into cell B3 and you want to put the result in the cell below (B4 in the Source Workbook )
So you put =sum(B3) in cell B4. But this is no good! You will only get the sum of the first cell of inserted data. You must use a Mirror Range to tell SpeedGen to stretch the formula to contain all inserted data. =sum(B3:B3) is the correct way to do this.
Let's say you want to calculate the sum of (B2 plus all Data Inserted into cell B3) and put the result in cell B4
Since you access a non-Field Marker Row in the range, no mirror ranges are required. Just put =sum(B2:B3) in cell B4.
See: Named Ranges
