Formula equivalent of CurrentRegion

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CurrentRegion - Usual Behavior? 2
Dependent drop down dynamic range formula, off sheet. 7
Excel VBA 1
Delete rows based on contents of Col A 0
Select a range not equal to: 4
Array formula lock-up 1
nested IF without repeating the condition? 1
Drop Down with dynamic named range offsheet source list 14

Back
Top