Export (0) Print
Expand All
Expand Minimize

Range.Areas Property (Excel)

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

expression .Areas

expression A variable that represents a Range object.

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.

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.

If Selection.Areas.Count > 1 Then 
 MsgBox "Cannot do this to a multi-area selection." 
End If
Show:
© 2014 Microsoft