Question about the @ sign in a Replace vba

[Ezguy4u]

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.

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

 

[Fluff]

The @ sign is just a place holder & could be anything that does not appear within the formula.
It is simply replaced with .Address by the Replace function.

 

[Ezguy4u]

Thanks Fluff, that did answer some of my questions.

 

[Fluff]

You're welcome & thanks for the feedback.