Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Union Two With Ranges
How would I union two set of ranges with an example listed below. Both Columns B and K start on row 2 since there is header information on column 1. Please help me with the code listed below. Thanks, With Range ("Staff_License").Range("b2:b") With Range ("Staff_Codes").Range("k2:K") For I = 2 to Row.count Next End With Column B Column K Staff License Staff Codes 0293 930090 6034 1237664 .... ... 7787 79289888 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
union of named ranges based only on the names of those ranges | Excel Programming | |||
printing Union of Ranges | Excel Worksheet Functions | |||
Union of Ranges Failed | Excel Programming | |||
union method for non-adjacent ranges | Excel Programming | |||
VBA union of two ranges | Excel Programming |