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