rownum = activecell.row
Rows(rownum & ":" & rownum+5).select

-----Original Message-----
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


.