Using text as a cell reference for a macro

Jazzmanstereo · Apr 9th, 2002, 06:29 AM

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.

Juan Pablo González · Apr 9th, 2002, 06:30 AM

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"

Apr 9th, 2002, 06:30 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 06:29 AM	#1
Jazzmanstereo New Member Join Date: Apr 2002 Location: England Posts: 10	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.