EvRNG 
You use the Range function to define cell ranges as function (such as EvDRE) parameters. For example, when you define a ColKey range for the EvDRE function, you enter a value like E2:E9. EvRNG makes it easy to select the range directly from the workbook, and returns the selected range as the value.
Features
When you use the EvRNG function to define a cell range, you can select the function, then press F2, and Excel highlights the range. This allows you to visualize the position of the range in the sheet.
During an expansion the parameters of the EvRNG function adjust themselves automatically when the body of the report redefines the number of rows and columns of the report. This self-adjustment allows EvDRE to retain the consistency of its parameters with the content of the report, permitting you to expand the same report multiple times, without breaking the definitions of its design. You must use EvRNG in these cells whenever the function uses expansions.
Activities
From the Excel interface, open the workbook in which you want to use the function and select the cell where you want to insert the function. Enter =EVRNG(, then select the desired range of cells.