Columns Method [Worksheet]

The Columns method returns a range object containing one or more entire columns of cells. Returns a WksRange object.

Syntax

object.Columns( Col1, Col2 )

 

Parameter	Type	Description
Col1	Variant	required, see remarks. The range may have a single column.
Col2	Variant	optional, see remarks

 

Remarks

See Specifying Cell Coordinates for more information on selecting cells.

Example

This example demonstrates how to change the cell color to green in columns A through C.

Wks.Columns(1, 3).Format.BackColor = grfColorGreen

 

Used by: Worksheet object