View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default What would the term be????

There are several terms that might be appropriate. A "Cell" is a
single cell, the intersection of a row and column. A "Range" is one or
more cells. An "Area" is a Range that is rectangular. Typically, a
Range has one Area, but this is not necessarily so. You can select a
Range that has several Areas by holding down the CTRL key when
selecting the cells.. The "CurrentRegion" of a Cell is the region that
includes the Cell and is bounded on all sides entirely by blank cells
or by the edge of the worksheet. "CurrentArray" refers to a Range that
is grouped together via an array formula that returns multiple cells
as its result. "Selection" refers to the Range(s) of cells that are
presently selected. (Technically "Selection" can refer to other types
of things, such as Shapes, but that is irrelevant here.) All of these
things refer to cells on a single worksheet. No flavor or a Range can
include cells on multiple worksheets.

By far, the term "Range" is the broadest and most widely used, and in
general parlance means simply "some cells on the worksheet".

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



On Thu, 20 Nov 2008 00:57:01 -0800, doss04
wrote:

Trying to use the right term for what i'm looking for. I dont think i have it
right. I have a group of cells and columns with individual information.
Example below. I thought it was a range of cells or am i looking for a term
not there?

A B C D E F G H I J
1
2
3
4
5
6 space space space space
7
8
9
and so on.