Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a subset of the following named ranges in several different
worksheets: A_1, A_2, ..., A_20, B_1, B_2, ..., B_20, C_1, C_2, ..., C_20 Is there a way I can get a collection of those that are available for a particular sheet using wildcards? For example, something like: for each oRange in WorkSheets("XXX").Range("A_*") ....processing... next oRange |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
WILDCARD CHARACTERS | Excel Programming | |||
Named Ranges - what characters are (or are not) allowed in the nam | Excel Discussion (Misc queries) | |||
Named Ranges - what characters are (or are not) allowed in the nam | Excel Discussion (Misc queries) | |||
WildCard Characters | Excel Worksheet Functions | |||
Deleting named ranges by looping through range collection | Excel Programming |