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