Thread: I can't convert text to a cell address

Below is my problem

Assume cell A1 contains a name and A2 contains the text "D7".

How would the code look like that
1. reads the contense in cell A2 (which is D7),
2. converts it (D7) to a cell address and finally
3. copies the content in cell A1 to the cell address found in A2 (in this case D7)

To illustrate I attached an Excel file.

Hi Dschmitt, you can try:

Range(Range("B1").Value).Value = Range("A1").Value