Excel.Application.Columns.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Application.Columns property (Excel)	vbaxl10.chm183087	vbaxl10.chm183087	Excel.Application.Columns	242d9112-9352-c3a6-e23e-59aec3d8f68f	04/04/2019	medium

Application.Columns property (Excel)

Returns a Range object that represents all the columns on the active worksheet. If the active document isn't a worksheet, the Columns property fails.

Syntax

expression.Columns

expression A variable that represents an Application object.

Remarks

Using this property without an object qualifier is equivalent to using ActiveSheet.Columns.

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—Selection.Columns.Count returns 2, not 4. To use this property on a range that may contain a multiple-area selection, test Areas.Count to determine whether the range contains more than one area. If it does, loop over each area in the range.

[!includeSupport and feedback]