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

CodePudding user response：

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