Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I make a cell's contents equal to another cell's contents with macro program?
I am writing macros that are run when you select an item from a list Then the macro inputs a particular cell’s contents into another cell The problem is the recording function of macro creates programming tha causes serious problems in spreadsheet if I add or delete cells. Here is an example of a macro: Sub AZWagePump3() ' ' AZWagePump3 Macro ' Macro recorded 8/19/2005 by Systems Administrator ' Range("B25").Select ActiveCell.FormulaR1C1 = "=R[181]C" Range("C25").Select ActiveCell.FormulaR1C1 = "=R[181]C" End Sub I am need a program that in essence is C4 = D4 so that what ever cell change around it the macro still functions correctly -- mgmcdevit ----------------------------------------------------------------------- mgmcdevitt's Profile: http://www.excelforum.com/member.php...fo&userid=2659 View this thread: http://www.excelforum.com/showthread.php?threadid=46797 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I make a cell's contents equal to another cell's contents w
If you are going to add/remove cells, rows or columns, you should assign
named ranges for your copy/paste targets. That way you can name them and forget them. ToPlace.value = FromPlace.value -- Gary''s Student "mgmcdevitt" wrote: I am writing macros that are run when you select an item from a list. Then the macro inputs a particular cells contents into another cell. The problem is the recording function of macro creates programming that causes serious problems in spreadsheet if I add or delete cells. Here is an example of a macro: Sub AZWagePump3() ' ' AZWagePump3 Macro ' Macro recorded 8/19/2005 by Systems Administrator ' Range("B25").Select ActiveCell.FormulaR1C1 = "=R[181]C" Range("C25").Select ActiveCell.FormulaR1C1 = "=R[181]C" End Sub I am need a program that in essence is C4 = D4 so that what ever cell I change around it the macro still functions correctly. -- mgmcdevitt ------------------------------------------------------------------------ mgmcdevitt's Profile: http://www.excelforum.com/member.php...o&userid=26592 View this thread: http://www.excelforum.com/showthread...hreadid=467971 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I make a cell's contents equal to another cell's contents with macro program?
I am not sure exactly what you mean. Could you explain it a little mor for me -- mgmcdevit ----------------------------------------------------------------------- mgmcdevitt's Profile: http://www.excelforum.com/member.php...fo&userid=2659 View this thread: http://www.excelforum.com/showthread.php?threadid=46797 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
link to a cell's contents | Excel Worksheet Functions | |||
link to a cell's contents | Excel Worksheet Functions | |||
link to a cell's contents | Excel Worksheet Functions | |||
macro to use a cell's contents as it's name | Excel Programming | |||
Macro Button To Modify A Cell's Contents? | Excel Programming |