PC Review


Reply
Thread Tools Rate Thread

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

 
 
Ellis Morgan
Guest
Posts: n/a
 
      6th Apr 2012
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
 
Reply With Quote
 
 
 
 
Jim Cone
Guest
Posts: n/a
 
      6th Apr 2012
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



 
Reply With Quote
 
 
 
 
Ellis Morgan
Guest
Posts: n/a
 
      7th Apr 2012
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
In the ItemCheck handler of a checked ListView, how to find the Item.text value of the row whose checked value changed? sherifffruitfly Microsoft C# .NET 3 29th Oct 2006 01:49 AM
Return to cell whose address is stored in different cell spydor Microsoft Excel Misc 1 30th Dec 2005 05:30 PM
IP address.if I have an address how can I find out whose it is? =?Utf-8?B?SWxlbmU=?= Windows XP Help 4 31st Jan 2004 03:44 AM
Validation rule trouble - ensuring values held in one field are less than those held in another field Joey P Microsoft Access Queries 2 7th Dec 2003 04:46 PM
Finding records whose ID is NOT IN another record set Van T. Dinh Microsoft Access Queries 0 11th Aug 2003 08:50 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:37 PM.