Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Union Method
Once rng4 has been set, the order of the unions is lost:
Sub Macro1() Dim r As Range For Each r In Selection MsgBox (r.Address) Next End Sub will produce the same messages if you select rng4 no matter how you originally set it up. -- Gary''s Student "Noah" wrote: Is it possible to use the Union method (or some other method) to join together multiple ranges in an order that is different original order of columns on the worksheet? For example, I would like rng4 in the macro below to have column B on the left, column C in the middle, and column A on the right. Thanks! Sub macro1() Sheets("Sheet1").Select Set rng1 = Range("A1:A100") Set rng2 = Range("B1:B100") Set rng3 = Range("C1:C100") Set rng4 = Application.Union(rng2, rng3, rng1) rng4.Copy Sheets("Sheet2").Range("A1") End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Union method for Range Object | Excel Programming | |||
Union Method with multiple worksheets | Excel Programming | |||
union method for non-adjacent ranges | Excel Programming | |||
union method for non-adjacent ranges | Excel Programming | |||
union method for non-adjacent ranges | Excel Programming |