Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selection.Copy issue
I am trying to copy a combination of a small contiguous range along with one
non-contiguous cell. The Selection.Copy command I am using is returning a "That command cannot be used on multiple selections". I have not been able to find the command that will do this. The related code I am using is below: Sheets("sheet1").Activate Set r1 = Range("B2:B8") Set r2 = Range("E1:E1") Set myMultiAreaRange = Union(r1, r2) myMultiAreaRange.Select MsgBox (myMultiAreaRange.Address) Selection.Copy Ideas?? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
Multiple range selection issue | Excel Programming | |||
Multiple range selection issue | Excel Discussion (Misc queries) | |||
Issue with selection boxes and if statements | Excel Programming | |||
Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue. | Excel Programming |