Range.Areas property (Excel)
Returns an Areas collection that represents all the ranges in a multiple-area selection. Read-only.
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
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.