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

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" <(E-Mail Removed)>
wrote in message
news:(E-Mail Removed)...
> 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

In article <jlndga$cr4$(E-Mail Removed)>, Jim Cone
<(E-Mail Removed)> 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