Excel Optimize

The following procedure demonstrates how to select the column that contains the active cell. It uses the EntireColumn property, which returns a Range object that consists of a full column:

Sub SelectColumn()
ActiveCell.EntireColumn.Select
End Sub

As you may expect, VBA also offers an EntireRow property, which returns a Range object that consists of an entire row.

This post placed under VBA Excel , column, Excel, select row, VBA code by Andrian
Top incoming search terms for this post
You might wanna see also these VBA Excel : Preventing Users from Inserting More Worksheets - Preventing Users from Printing a Workbook - Preventing Save As in a Workbook - Loading Add-ins Automatically - Do-Until loop - Do-While loop - Nested For-Next -