VBA Replace

[Ezguy4u]

So I just want to join the letters in column B to the numbers in columns C, D & E. See examples below. I would like to use the VBA code below but the .Value line gives me a list and separator error. It could be the syntax or maybe I am just doing it all wrong. Any help would be appreciated and thank you for your time.

Sub test3B()

With Range("C1:E2")

.Value = Replace("Range("B1:B2")" & "&@", "@", .Address)

  End With

End Sub

Input

06 Replace Evaluate If rev a.xlsm
	B	C	D	E
1	A	1	2	3
2	B	4	5	6
3	C	7	8	9
Count Rows Col workin 1

Output

06 Replace Evaluate If rev a.xlsm
	B	C	D	E
1	A	A1	A2	A3
2	B	B4	B5	B6
3	C	C7	C8	C9
Count Rows Col workin 1

 

[Peter_SSs]

Peter, the first assumption is accurate, there is no data in column A.

Fair enough. It is just that it is slightly unusual to have a blank column A and we only know what you show and/or tell us, and column A was not shown in your mini-sheets.
Anyway, glad you have something that works for you.