Selecting A Row Or Column

To select the entire column we can use the EntireColumn property. The following excel VBA macro example demonstrates how to select the column of the active cell.

Sub SelectColumn()
ActiveCell.EntireColumn.Select
End Sub

The next following excel VBA macro example demonstrates how to perform an operation on all cells in the selected row. This following procedure changes all cells font size to 18 in the row that contains the active cell.

Sub ChangeFontSize()
ActiveCell.EntireRow.Font.Size = 18
End Sub

Thank you for reading this article Selecting A Row Or Column With URL https://x-tutorials.blogspot.com/2009/02/selecting-row-or-column.html. Also a time to read the other articles.