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