VBA: range selection

Question

I would like to ask, if I need to select an entire row, start from the 3rd row as a range in VBA, instead of the below line, any better ways to go about it? Many thanks.

Range("C3:C1048576").Select

Answer 1

Assuming your working with an Excel Worksheet, this line will do it ActiveWorkbook.Worksheets(1).Rows(3).Select