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

--
HTH

Bob Phillips

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