selecting multiple rows
 

Try this with resize

Rows(ActiveCell.Row).Resize(5).Select


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Stuart" wrote in 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

selecting multiple rows
 

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

selecting multiple rows
 

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


.