Areas Command in Excel

 

What Does It Do?

This function tests a range to determine whether it is a single block of data, or whether it is a multiple selection.

If it is a single block the result will be 1.

If it is a multiple block the result will be the number of ranges selected.

The function is designed to be used in macros.

Syntax

=AREAS(RangeToTest)

Formatting

Example

The example at the top of this page shows two ranges coloured pink and green.

These ranges have been given the name PeopleLists.

The =AREAS(PeopleLists) gives a result of 2 indicating that there are two separate

selections which form the PeopleLists range.

Note

To name multiple ranges the CTRL key must be used.

In the above example the pink range was selected as normal, then the Ctrl key was held down before selecting the green range.

When a Range Name is created it will consider both Pink and Green as being one range.