Turn Selection
This changes the Active Cell within a Range.
In case a Range like A1:A50 is selected, with A1 beeing the Active Cell, Turn Selection will change the Active Cell to A50.
This tool only works with 1 area of cells selected. A dialog will popup and give a warning if the Range consists of multiple areas as well as if the Range does only contain one single cell.
Alternatively, run this tool by pressing [Ctrl]+[Shift]+T.
See also:
Copy From Active to Last Selected Cell
Last Row in Column
Last Column in Row
Goto Last / Select until Last