Select cell with variable reference

I'm not able to get the following problem solved in Excel.

I've written a macro. In this macro the value of cell C1 has to be copied to a cell in the worksheet. The value of the destination cell is variable and displayed in cell D1.

so if the value of cell D1 = "AA10" then the value of C1 has to be copied in cell AA10

if the value of cell D1 = "Q34" for instance, the value of cell C1 has to be copied to cell Q34.

So the value of the destination cell is in D1 and can be almost every value of the worksheet because it's the result of a SEEK function.

Can anyone help me figure this one out.

Thanks!

Hello Haan0054,

The referencing you are doing isn't possible with Worksheet Formulas. You have to use VBA to construct a macro to achieve your result.

Macro Code:

Sub CopyIndirect(Destination_Address As String, Source_Address As String)
With ActiveSheet
IndirectDstAddx = .Range(Destination_Address).Value
.Range(IndirectDstAddx).Value = .Range(Source_Address).Value
End With
End Sub

Copy and Paste this code into a VBA Module in your Project. If you have any questions or need additional help, e-mail me [email protected].


Sincerely,
Leith Ross