VBA for Text/Cells merge

Giganews Newsgroups
Subject: VBA for Text/Cells merge
Posted by:  Ron (mc28…@mclink.it)
Date: Fri, 19 May 2006

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.