Your help here would be great .....

I am trying to use an excel macro to select 2 ranges on the same sheet:
- the first range is A1:G56
- the second range is I59 to the last active cell. This last active cell is always in column I and is always at least 10 rows greater than row 59.
The problem is that the macro that excel generates (below) always selects A1:I(x) where x is the last row number. eg if the last active cell in column I is 90, A1:I90 is selected. The ranges I do not need selected are A57:G90 and I1:I55.

Range("A1:G56,I59").Select
Range("I59").Activate
Range(Selection, ActiveCell.SpecialCells(xlCellTypeLastCell)).Select
Range(Selection, Selection.End(xlUp)).Select

Would really appreciate your help on this one.
Cheers
Marc