Help for VBA Text Merge

[Ron]

Please help to code the following

A B C D
1 bbb
2 ccc
3 kkk
4 yyy

Merge text cells B1 & B2;
B3 & B4 etc.......

the results displayed in A1; A2; etc

There are no blank cells in the B col range.

TIA

Ron

[papou]

Hello
You don't need any code for this.
Instead use a formula in A1 :
=B1&B2
you can then drag down to your other cells in column A

HTH
Cordially
Pascal

"Ron" <mc2835@mclink.it> a écrit dans le message de news:
meam629m34c4seqhlh2v6ojrsdkng7ioab@4ax.com...
> Please help to code the following
>
> A B C D
> 1 bbb
> 2 ccc
> 3 kkk
> 4 yyy
>
> Merge text cells B1 & B2;
> B3 & B4 etc.......
>
> the results displayed in A1; A2; etc
>
> There are no blank cells in the B col range.
>
> TIA
>
> Ron

[Ron]

Pascal,

Many thanks for your suggestion but I do need the merged text in Col A
to do some more text manipulation, editing and copying.

Best wishes

Ron

On Wed, 17 May 2006 16:30:56 +0200, "papou" <cestpasbon@çanonplus>
wrote:

>Hello
>You don't need any code for this.
>Instead use a formula in A1 :
>=B1&B2
>you can then drag down to your other cells in column A
>
>HTH
>Cordially
>Pascal
>
>"Ron" <mc2835@mclink.it> a écrit dans le message de news:
>meam629m34c4seqhlh2v6ojrsdkng7ioab@4ax.com...
>> Please help to code the following
>>
>> A B C D
>> 1 bbb
>> 2 ccc
>> 3 kkk
>> 4 yyy
>>
>> Merge text cells B1 & B2;
>> B3 & B4 etc.......
>>
>> the results displayed in A1; A2; etc
>>
>> There are no blank cells in the B col range.
>>
>> TIA
>>
>> Ron
>