Formula equivalent of CurrentRegion

Hi,

In VBA a range object has a property of CurrentRegion which is really useful
in picking up the cells in a dynamic data table. Does anyone know an elegant
way to return the same range information using formulae? I am trying to
avoid using long reaching references such as $1:$1 or $A:$A.

Take a look at http://www.xldynamic.com/source/xld.LastValue.html

--
HTH

Bob Phillips

"bdr200" <bdr200@discussions.microsoft.com> wrote in message
news:74BFA720-0056-4E85-A33C-B545CE9ADE01@microsoft.com...
> Hi,
>
> In VBA a range object has a property of CurrentRegion which is really
useful
> in picking up the cells in a dynamic data table. Does anyone know an
elegant
> way to return the same range information using formulae? I am trying to
> avoid using long reaching references such as $1:$1 or $A:$A.