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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 02:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com