I expect Excel might, one day, catch up with this functionality that Lotus
123 has had for years and years. However, we have to bear in mind that "..
Excel is not a Lotus 123 clone ..".

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Mike Barlow" wrote in message
...
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