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.