OR try:


Sub Button1_Click()
With Sheet1
Range("A3").Value = Range("A1").Value & Range("A2").Value
End With

End Sub



Corey....
"kk" wrote in message
...
I tried recording macro and it does not work with relative addressing.

A1 abc A2 xyz

I want A3 to be abcxyz

If you run above recorded macro for cells B1 B2 and B3 I get copy of A1 A2
A3
not the real content of B1 and B2

Thanks for your help!