Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I stop Excell selecting multiple rows? | Excel Discussion (Misc queries) | |||
Selecting multiple rows | Excel Discussion (Misc queries) | |||
selecting multiple rows within a Macro | Excel Programming | |||
selecting multiple rows within a Macro | Excel Programming | |||
selecting multiple rows within a Macro | Excel Programming |