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

Discussion in 'Microsoft Excel New Users' started by Ellis Morgan, Apr 6, 2012.

  1. Ellis Morgan

    Ellis Morgan Guest

    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
     
    Ellis Morgan, Apr 6, 2012
    #1
    1. Advertisements

  2. Ellis Morgan

    Jim Cone Guest

    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
    news:...
    > 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, Apr 6, 2012
    #2
    1. Advertisements

  3. Ellis Morgan

    Ellis Morgan Guest

    In article <jlndga$cr4$>, 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
     
    Ellis Morgan, Apr 7, 2012
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    cell value depends on value in another cell question

    Guest, May 13, 2004, in forum: Microsoft Excel New Users
    Replies:
    2
    Views:
    733
  2. Guest

    I need to increase a number which is held in a cell by 1

    Guest, Jan 14, 2005, in forum: Microsoft Excel New Users
    Replies:
    1
    Views:
    219
    Bob Phillips
    Jan 14, 2005
  3. sdm
    Replies:
    4
    Views:
    187
  4. srinivas
    Replies:
    1
    Views:
    214
    Peo Sjoblom
    Oct 3, 2008
  5. vpmedia

    Scanning with a hand held unit?

    vpmedia, Mar 13, 2010, in forum: Microsoft Excel New Users
    Replies:
    4
    Views:
    887
Loading...

Share This Page