Select Range

[Jodie]

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

[Jim Thomlinson]

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

[K Dales]

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

[Doug Glancy]

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" <[email protected]> wrote in message
news:[email protected]...
> 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