Using text as a cell reference for a macro
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Using text as a cell reference for a macro

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    England
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Basically what i want is to run a macro that selects a cell and then uses the text within another to decide on the destination for what its copied.

    Its for an order form where i want it to give the customer reward points. These will be decided within the order form and added to the customers details for future use.

    Please help me out, it seems impossible to get my teacher to pay any attention to me in class and this is just beyond my meager brain at the moment.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    You can read the contents of a cell with:

    MyAddress = Range("A1")

    and you can use that result with something like

    Range(MyAddress) = "Whatever you want here"
    Regards,

    Juan Pablo González
    http://www.juanpg.com

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com