- Name file: LIB_File.bas
Return the address of the specified range (eg. $A$1)
- cell as Range: the specified range
- Return the absolute address of the range
Simulate the CTRL + SHIFT + DOWN from a specified range. Returns the range that should be selected. For VBA users: returns the cell.end(xlDown) related range.
Note: this could be a replacement of the Dymanic Ranges. Use one of the other method when best appropriated.
- cell as Range: the specified range
- No Performance tests have been perfomed
- Will end before the first empty cell
- If the next cell is empty, the function will return only the specified cell
- Can not be used in Name Manager
Example: =sum(selectXlDownRange(b3)) will sum all the values of the cell from b3 until b4, b5,... until Excel finds an empty cell