Useful information if VBA operations need to be performed on Columns or Rows.

Columns

Columns(2).Select

This will select specific column. In this example, column B would have been selected

Rows

Rows(7).Select

Example above will select specific row. In this case, row 7 would have been selected.

Ranges

Columns and rows can also be selected/ used by specifying a range.

Rows("5:7").Select
Columns("B:E").Select
Source
https://www.excel-easy.com/vba/examples/entire-rows-columns.html

Categorized in:

VBA Excel,

Last Update: May 18, 2024