Hello, I am running Excel 2003 on Windows XP and hope some one can please help me fix my VBA macro:
Sub Concatenate_TextColumns()
Dim FirstGivenName As Variant
Dim SecondGivenName As Variant
‘
Range("G2").Select
‘
For Each SecondGivenName In Range("F2:F65500")
For Each FirstGivenName In Range("E2:E65500")
ActiveCell.Formula = FirstGivenName & " " & SecondGivenName
ActiveCell.Offset(1, 0).Select
Next
Next
‘
Range("G1").Select
‘
End Sub
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
Bookmarks