RE: VBA for Text/Cells merge

Giganews Newsgroups
Subject: RE: VBA for Text/Cells merge
Posted by:  CLR
Date: Fri, 19 May 2006

You could do it with formulas, just put this in A1 and copy down, then Copy >
PasteSpecial > Values, and delete the blanks...

=IF(ISODD(ROW(B1)),B1&OFFSET(B1,1,0),"")

Vaya con Dios,
Chuck, CABGx3

"Ron" wrote:

> With Excel 2002 I need some help please to VBA code the following
>
>        A        B        C      D
> 1              bbb
> 2              ccc
> 3              kkk
> 4              yyy
>
> Merge text cells B1 & B2;
>                        B3 & B4..... etc.......
>
> The merged results should be displayed in A1; A2; etc
>
> Col B varies on a daily basis but is rarely less that 1500 cells.
>
> There are no blank cells in the B col range.
>
> TIA
>
> R.

Replies

In response to

VBA for Text/Cells merge posted by Ron on Fri, 19 May 2006