Hello -

I propose that a RANGE() function be added that is equivalent to the
existing ADDRESS() function or a shorthand equivalent to
CONCATENATE(ADDRESS(),":",ADDRESS()). Indirect addressing is useful when
dealing with real-world data of variable extent or quality.

I further propose that a notation such as ADDRESS({$A$10},{$A$10}) and
ADDRESS({{$A$10}}) be allowed as equivalent to
ADDRESS(ROW($A$10),COLUMN($A$10)) for additional notation simplification when
specifying indirect addresses or address ranges. The second form above would
be applicable as part of a variable RANGE() function where one point is
fixed. If all points are fixed, then there is no point in using an indirect
range or address.

Note that using sheet cell references allows these formulas to reflect
changes in sheet structure (add/remove columns or rows) as long as those
references are at the corners of the intended range and are not deleted by
these operations.

Thanks.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions