Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Range
How do I select the range that starts 5 cells below the current selection
down 300 cells. ie. Current cell c5 select C10:c300. Thanks for your help, you guts are great! Jodie |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Range
Ok you have lost me... Is the 300 a static number or should your question
have been Current C5 then Select C10 - C305... If the latter then try... range(activecell.offset(5,0), activecell.offset(300, 0)).select HTH "Jodie" wrote: How do I select the range that starts 5 cells below the current selection down 300 cells. ie. Current cell c5 select C10:c300. Thanks for your help, you guts are great! Jodie |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Range
If instead you actually do want it always to end in row 300, make it:
range(activecell.offset(5,0), activecell.offset(300-activecell.row, 0)).select "Jim Thomlinson" wrote: Ok you have lost me... Is the 300 a static number or should your question have been Current C5 then Select C10 - C305... If the latter then try... range(activecell.offset(5,0), activecell.offset(300, 0)).select HTH "Jodie" wrote: How do I select the range that starts 5 cells below the current selection down 300 cells. ie. Current cell c5 select C10:c300. Thanks for your help, you guts are great! Jodie |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Range
Jodie,
Depending on the interpretation of your question - either down 300 rows or down to row 300, try these: ActiveCell.Offset(5, 0).Resize(300, 1).Select or ActiveCell.Offset(5, 0).Resize(296 - ActiveCell.Row, 1).Select Note that the second will error if your activecell is in row 296 or higher. hth, Doug Glancy "Jodie" wrote in message ... How do I select the range that starts 5 cells below the current selection down 300 cells. ie. Current cell c5 select C10:c300. Thanks for your help, you guts are great! Jodie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can change range to select active rows instead of :=Range("S10 | Excel Discussion (Misc queries) | |||
When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
Select Using Range | Excel Discussion (Misc queries) | |||
Range select | Excel Programming | |||
Select Sheet then Select Range | Excel Programming |