Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
Areas Interface
Definition
- Namespace:
- Microsoft.Office.Interop.Excel
- Assembly:
- Microsoft.Office.Interop.Excel.dll
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
A collection of the areas, or contiguous blocks of cells, within a selection.
public interface class Areas : System::Collections::IEnumerable[System.Runtime.InteropServices.Guid("00020860-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface Areas : System.Collections.IEnumerablePublic Interface Areas
Implements IEnumerable- Attributes
- Implements
Remarks
There’s no singular Area object; individual members of the Areas collection are Range objects. The Areas collection contains one Range object for each discrete, contiguous range of cells within the selection. If the selection contains only one area, the Areas collection contains a single Range object that corresponds to that selection.
Use the Areas property to return the Areas collection.
Use Areas(index), where index is the area index number, to return a single Range object from the collection. The index numbers correspond to the order in which the areas were selected.
Some operations cannot be performed on more than one area in a selection at the same time; you must loop through the individual areas in the selection and perform the operations on each area separately.
Properties
| _Default[Int32] |
Reserved for internal use. |
| Application |
Returns an Application object that represents the Microsoft Excel application. |
| Count |
Returns the number of objects in the collection. |
| Creator |
Returns a 32-bit integer that indicates the application in which this object was created. |
| Item[Int32] |
Returns a single object from a collection. |
| Parent |
Returns the parent object for the specified object. |
Methods
| GetEnumerator() |
Applies to
Feedback
Was this page helpful?