| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Count the items in a named range
I have a dynamic range named Cable_1 that uses an OFFSET formula in the refers to box. =OFFSET('Cable Lists'!$C$2,0,0,COUNTA('Cable Lists'!$C:$C),1)
I have used various methods of setting to range and such, but cannot get the occupied rows count. i.e. Range("Cable_1").Rows.Count The actual named range uses the formula like this, pulled down, to make a continuous list. =IF(ROW(A2)-ROW(A$2)+1COUNT(B$2:B$13),"",INDEX(A:A,SMALL(B$2: B$13,1+ROW(A2)-ROW(A$2)))) Thanks for taking a look. Howard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation; add items to named range | Excel Discussion (Misc queries) | |||
| Count items in range | Excel Worksheet Functions | |||
| Count unique items in range | Excel Worksheet Functions | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
| Selecting Filtered Items from Named range | Excel Programming | |||
Threaded Mode
