Dynamic Range: limit ?

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

Guest

Hello
I have this linked to a name "Members"
=OFFSET(Historique!$A$2;;;COUNTA(Historique!$A:$A);COUNTA(Historique!$A$2:$AL$2))

For a reason that I do not know (a limitation ?) the range is not going to
AL column but well till column AI.

Anyone has an idea why this is the case ?

Many thanks

François
 
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

How I can set dynamic pivot table ONLY when I have enough data point 1
Multiple Dynamic Named Ranges across Columns 3
Trouble with dynamic named range 4
Post my named ranges in column A 10
DYNAMIC RANGE FOR PIVOT TABLE 1
Dynamic Range & Offset code problem 3
Large Dynamic Named Range Sort Problem 3
Preventing corruption of dynamic range names on cell deletion 1

Back
Top