| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Relative Addresses in equations
I am trying to write a Macro that will write an equation into the
spreadsheet. This equation includes references to other cells. I want the equation to be linked to the other cell after the program is run. (If the macro enters an eq. into cell A4 that depends on A1, the value of A4 should change whenever I change the value in A1.) The problem is that I will find the address earlier in the macro. Here is a simplification: if MyRange is the cell I want to link to (A1) ActiveCell.FormulaR1C1 = "=14-" & Range(myRange) the equation in A4 should be "=14-A1" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro - getting relative cell addresses to flow down | Excel Discussion (Misc queries) | |||
| How do I record a macro with relative cell addresses? | Excel Discussion (Misc queries) | |||
| How do I change a macro to use relative cell addresses? | Excel Discussion (Misc queries) | |||
| How do I change a Macro to use relative cell addresses? | Excel Discussion (Misc queries) | |||
| Using Relative Addresses to Select Columns | Excel Programming | |||
Threaded Mode
