| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I select multiple selections using the range(cell(),Cell())
HI all.
I need to select for instance Range("B2:J2,E4:K4") However this is going to be a dynamic selection process (for charts), and I need to be able to use variables, which, for me, is much easier using the Range(Cell(),Cell()) method. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I select multiple selections using the range(cell(),Cell())
Dim rng1 as Range, rng2 as Range
Dim rng3 as Range set rng1 = Range(Cell(),Cell()) set rng2 = Range(Cell(),Cell()) set rng3 = Union(rng1,rng2) -- Regards, Tom Ogilvy "havocdragon" wrote: HI all. I need to select for instance Range("B2:J2,E4:K4") However this is going to be a dynamic selection process (for charts), and I need to be able to use variables, which, for me, is much easier using the Range(Cell(),Cell()) method. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple selections of rows & columns by clicking in one cell | Excel Worksheet Functions | |||
| Excel--Can you select multiple selections in a drop down list? | Excel Discussion (Misc queries) | |||
| Enabling multiple selections in same cell from dropdown menu | Excel Discussion (Misc queries) | |||
| Apply formula to a range with multiple selections | Excel Programming | |||
| Creating Multiple GIFs from Multiple Range selections -- I need a volunteer to test my code to see why it fails | Excel Programming | |||
Linear Mode
