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" <[email protected]> wrote in message
news:[email protected]...
> 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...heet.functions
Bookmarks