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.
Input
Output
VBA Code:
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 |