This documentation is archived and is not being maintained.

Range.Columns Property 

Returns a Range object that represents the columns in the specified range.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

'Usage
Dim range1 As Range

Dim returnValue As Range
returnValue = range1.Columns

Range Columns {get;}
public Range get_Columns();
function get Columns() : Range;

When applied to a Range object that's a multiple-area selection, this property returns columns from only the first area of the range. For example, if the Range object has two areas — A1:B2 and C3:D4 — the Count property returns 2, not 4. To use this property on a range that may contain a multiple-area selection, test the Count property of the Areas object to determine whether the range contains more than one area. If it does, loop over each area in the range.


Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Show: