| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I write macros with relative reference cells
I have written a macro , basically a black sholels model for random
simmulation, that works only as long as I do not change the spread sheet after the macro is recorded. If I add or delete a row or column, then the macro blows up. I believe the problem is that the cell references in the macro are specific to each cell when recorded. Is there a way around this problem? John Lynch |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Cells from Relative to Absolute Reference | Excel Discussion (Misc queries) | |||
| Relative Reference Help Macros | Excel Worksheet Functions | |||
| How do I get relative/absolute reference button (macros) | Excel Discussion (Misc queries) | |||
| Macros - Relative cells in Excel | Excel Programming | |||
| relative reference button missing for recording macros | Excel Programming | |||
Threaded Mode
