That is the question :)
Range Stretching is the basic SpeedGen Concept you'll need to understand. It is what makes SpeedGen so powerful. When Stretching is enabled you don't need to know exactly how how many rows of data you will be inserting, SpeedGen will stretch your ranges to fit the data. Automatically.
All changes caused by Stretching are automatically propagated to all other Formulas & Ranges in the Workbook, even when you reference cells on other Sheets. So you only need to know where the cells exist in the Source Workbook and not in the Generated Workbook. SpeedGen does the hard work for you.
Here are some simple examples to help you understand how it works:
| Source Workbook | Generated Workbook | |||||||||||||||
 |
 |
|||||||||||||||
|
||||||||||||||||
The table above shows just the most basic examples, to fully understand Stretching you can study the samples
Stretching is enabled by default but you can disable it with the Stretch property.
