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

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

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

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"
wrote in message
...
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

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

In article , Jim Cone
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