Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to connect two columns in Excel VBA
Hello ,
Could you tell me how to in easy way connect two columns. I have _____A_____B______C_____ 1 | string | text | stringtext | 2 | string | text | stringtext | 3 | string | text | stringtext | 4 | string | text | stringtext | ........................... 40| string | text | stringtext | 41| etc.. | etc.. | stringtext | Can I do it in a way that i have Dim Rng1 As Range Dim Rng2 As Range Set Rng1 = Range("A:A").SpecialCells(xlCellTypeConstants) Set Rng3 = Range("B:B").SpecialCells(xlCellTypeConstants) Is there an easy function to connect these defined Ranges, Rng1 and Rng2?? Thanks for response |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to connect two columns in Excel VBA
the code statemen will be somethinglike this
Range("c1") = Range("a1") & Range("B1") space before and after & sign ============= wrote in message oups.com... Hello , Could you tell me how to in easy way connect two columns. I have _____A_____B______C_____ 1 | string | text | stringtext | 2 | string | text | stringtext | 3 | string | text | stringtext | 4 | string | text | stringtext | .......................... 40| string | text | stringtext | 41| etc.. | etc.. | stringtext | Can I do it in a way that i have Dim Rng1 As Range Dim Rng2 As Range Set Rng1 = Range("A:A").SpecialCells(xlCellTypeConstants) Set Rng3 = Range("B:B").SpecialCells(xlCellTypeConstants) Is there an easy function to connect these defined Ranges, Rng1 and Rng2?? Thanks for response |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OLE DB provider cannot connect to Excel 2007 with 400 columns | Excel Discussion (Misc queries) | |||
How to connect two columns in Excel VBA?? | Excel Worksheet Functions | |||
Connect columns, with restrictions | Excel Worksheet Functions | |||
Connect multiple columns in 1 row to another? | New Users to Excel | |||
Excel-SQL Connect | Excel Programming |