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
Access the collection of all ranges in a multiple area selection? areas Areas Property Get a list of all ranges in a selected area?

See also: