Entire Rows and Columns in Excel VBA

This example teaches you how to select entire rows and columns in Excel VBA. Are you ready?

Place a command button on your worksheet and add the following code lines:

1. The following code line selects the entire sheet.

Note: because we placed our command button on the first worksheet, this code line selects the entire first sheet. To select cells on another worksheet, you have to activate this sheet first. For example, the following code lines select the entire second worksheet.

2. The following code line selects the second column.

3. The following code line selects the seventh row.

4. To select multiple rows, add a code line like this:

5. To select multiple columns, add a code line like this:

6. Be careful not to mix up the Rows and Columns properties with the Row and Column properties. The Rows and Columns properties return a Range object. The Row and Column properties return a single value.

Code line:

Result:

7. Select cell D6. The following code line selects the entire row of the active cell.

Note: borders in the image for illustration only.

8. Select cell D6. The following code line enters the value 2 into the first cell of the column that contains the active cell.

Note: borders in the image for illustration only.

9. Select cell D6. The following code line enters the value 3 into the first cell of the row below the row that contains the active cell.

Note: borders in the image for illustration only.

If you're new here, welcome to Excel Easy! Join over 1 million monthly Excel learners. You can find popular courses here: Data Analysis in Excel and Excel VBA.