|Subject:||RE: VBA for Text/Cells merge|
|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...
Vaya con Dios,
> 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.
VBA for Text/Cells merge posted by Ron on Fri, 19 May 2006