View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dean P. Dean P. is offline
external usenet poster
 
Posts: 12
Default 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