how do i select multiple rows from within VBA, I need something simillar to
the following, obviously the following line does not work, however it should
give you the idea of what I am after. i.e. select the row of the activecell
along with the five rows below it!

Rows(ActiveCell.Row, ActiveCell.Offset(5, 0)).Select