Select the first 1000 cells of Column A
Sub Select1000Cells()
Range("A1:A1000").Select
End Sub
Select a specific data range in a worksheet
Sub Select40Cells()
Range("D10:K23").Select
End Sub
Sub Select1000Cells()
Range("A1:A1000").Select
End Sub
Sub Select40Cells()
Range("D10:K23").Select
End Sub