Merge the contents of 2 cells into another 3rd cell using VBA in Excel

Question

Hi everybody, I have two cells lets say: A1 and A2

The content of each one of them is a string:

A1: Hallo

A2: World

My goal is to merge the contents of A1 and A2 in another cell e.g. A3 i.e. A3's content should be:

Hallo World

I would like to do this using a VBA macro and not only for strings as contents..

Thanks both of u for your answers!!

Answer 1

I suggest either an Excel formula (=A1&A2) or the VBA macro of Range("A3").Cell.Value = Range("A1").Cell.Value & Range("A2").Cell.Value