Selecting a column works exactly the same way. Just use the Columns method.
Here’s an example:
Here’s what we get:
Again, remember that the number you use refers to the column within your selection, not the spreadsheet at large.
If you want to select rows and columns in the spreadsheet at large, don’t write newRange before it:
Rows(3).Select <-- this selects the entire row 3 of the spreadsheet
Columns(2).Select <– this selects the entire column 2 of the spreadsheet
Range(“B:B”).Select <– this selects the entire column B of the spreadsheet
Range(“3:3”).Select <– this selects the entire row 3 of the spreadsheet