Areas Property
TOC
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

Range.Areas Property

Office 2007
Returns an Areas collection that represents all the ranges in a multiple-area selection. Read-only.

Syntax

expression.Areas

expression   A variable that represents a Range object.

Remarks

For a single selection, the Areas property returns a collection that contains one object — the original Range object itself. For a multiple-area selection, the Areas property returns a collection that contains one object for each selected area.

Example

This example displays a message if the user tries to carry out a command when more than one area is selected. This example must be run from a worksheet.

Visual Basic for Applications
If Selection.Areas.Count > 1 Then
    MsgBox "Cannot do this to a multi-area selection."
End If



Show:
© 2016 Microsoft