I have a question about the vba program below. Now I have boiled down another program to the one below. The input and output is also below and all it does is joins the letters in column A to the numbers in the array. What I would like to focus in on is that @ sign and how it works. If possible a link to even more information about how this @ sign is working. Any way I appreciate any help and thanks for your time.
VBA Code:
Sub Join1()
With Range("B1:D3")
.Value = Evaluate(Replace("IF(@="""","""",A1:A3 &@)", "@", .Address))
End With
End Sub
08 20-09-21 join cells Rick work 4.xlsm | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | A | 1 | 2 | 3 | ||
2 | B | 4 | 5 | |||
3 | C | 6 | 7 | |||
Join |
08 20-09-21 join cells Rick work 4.xlsm | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | A | A1 | A2 | A3 | ||
2 | B | B4 | B5 | |||
3 | C | C6 | C7 | |||
Join |