Edit

Share via

Range.Areas property (Excel)

  • Article

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.

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.