| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A range variable consisting of multiple ranges.
Is it possible to do the following
- There are two names in a sheet: test1 = "A1:A3" and test2 = "D12:D16" - I would like to define a single range variable: Dim testing As Range Set testing = Union (ThisWorkbook.Names"test1").RefersToRange, ThisWorkbook.Names("test2").RefersToRange) I know that this does not work, but is there a way to fix it ? Thanks, pac |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Range matching multiple named Ranges | Excel Discussion (Misc queries) | |||
| Countif & ranges consisting of multiple areas | Excel Worksheet Functions | |||
| Countif & ranges consisting of multiple areas | Excel Worksheet Functions | |||
| Countif & ranges consisting of multiple areas | Excel Worksheet Functions | |||
| Countif & ranges consisting of multiple areas | Excel Worksheet Functions | |||
Threaded Mode
