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
If you like posts in this blog, you can to support me :)