Concatenate two columns VBA macro

Hello, I am running Excel 2003 on Windows XP and hope some one can please help me fix my VBA macro:

Please Login or Register  to view this content.

The following image shows what I want and what I acrually get:

Figures 1 and 2.jpg

I have just re-edited this post with better screen-shots below:

Figure 1 - shows what I do want:

Figure 1.jpg

Figure 2 - shows what I am getting when I run the above macro (which I do not want):

Figure 2.jpg


Kind regards,

Chris

you don't need 2 for cycle

Please Login or Register  to view this content.