Auto Select First Row To Last Row With Data

[HaroonSid]

hello
i have a range c10:c300, i want to select the range where i have data.
e.g
i have data in c10:c50, then select the range c10:c50

thanx

[stnkynts]

Maybe:

Range("C10:C300").SpecialCells(xlCellTypeConstants).Select

[HaroonSid]

Hello
stnkynts

thanx its working, but if there is no data in range c10:c300 then there is coming up a bebug
how to solve

[stnkynts]

Maybe this

On Error Resume Next
Range("C10:C300").SpecialCells(xlCellTypeConstants).Select