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?
--
Ellis Morgan

[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" <el...@nospam.demon.co.uk>
wrote in message
news:HYPSVWGO...@mrtlfrm.demon.co.uk...

[Ellis Morgan]

In article <jlndga$cr4$1...@speranza.aioe.org>, Jim Cone
<james....@comcast.netXxx> writes

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

Thanks Jim, just what I needed.
--
Ellis Morgan