| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Range: limit ?
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Dynamic Range: limit ?
Problem solved already. Some cells were empty.
Sorry for this. "François" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| range limit | Excel Discussion (Misc queries) | |||
| Range limit of CF | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Limit cursor range | Excel Worksheet Functions | |||
| Excel 2000 VBA - Set Print Range in dynamic range | Excel Programming | |||
Hybrid Mode
