Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding to a selection?
Can someone tell me how to add to an existing selection?
For example: Range("A1, C1").Select .....then later on I want to keep "A1" and "C1" selected, but add on more selected more cells. In "english" it would be Selection = Selection + New Selection Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding to a selection?
You can use Union to combine ranges. But it's not usually required to select
any range to work on them. dim myRng as range set myrng = .range("a1:C1") 'myrng.select set myrng = union(myrng, range("d3:d77")) 'myrng.select wrote: Can someone tell me how to add to an existing selection? For example: Range("A1, C1").Select ....then later on I want to keep "A1" and "C1" selected, but add on more selected more cells. In "english" it would be Selection = Selection + New Selection Thanks! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill/Expand Selection adding placeholders to Decimals | Excel Discussion (Misc queries) | |||
Adding another selection to a drop down list | Excel Discussion (Misc queries) | |||
adding to different totals dependant upon selection from drop down | Excel Worksheet Functions | |||
Adding time selection to pop-up calendar | Excel Programming | |||
Adding current selection | Excel Programming |