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").