vba select a range of cells
 

I am trying to select a range of cells from the current active cell and
up to the first cell.
For example the current active cell is G26 I would like to select G26
to G1, but keep in mind the rows are never going to be the same.
currently If working in excel I would hold shift and press page up.