Working with a range to the left and/or above the active cell

This has to be done in two stages, first to change the active cell and then second specify the range relative to the new active cell. For example:

ActiveCell.Cells(-1, -1).Activate()

ActiveCell.Range("a1..a5").Select()

This is necessary because there is no way to specify a range like Range("-a1, -a10").