How to set a value in a cell whose address is held in another cell

[Ellis Morgan]

Say I have A1=4 and A2="D3", can I write a macro to set D3=4, using the
information in A1:A2?

 

[Jim Cone]

Sub MakeItReal()
Dim strText As String
strText = Range("A2").Text
Range(strText).Value = Range("A1").Value
End Sub
--
Jim Cone
Portland, Oregon USA .
http://www.mediafire.com/PrimitiveSoftware .
(Data Options add-in: row stuff/date picker/random stuff)



"Ellis Morgan" <[email protected]>
wrote in message
news:[email protected]...

 

[Ellis Morgan]

Sub MakeItReal()
Dim strText As String
strText = Range("A2").Text
Range(strText).Value = Range("A1").Value
End Sub

Thanks Jim, just what I needed.