| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Module to make all absolute references relative
I'm using absolute references to allow a set of formulas to be copied across
and down a spreadsheet with only certain values changing relatively. After the formulas are in place, I need all absolute references to be returned to relative references so the sheet will still function when it is reformatted, parts added/removed etc... Couldn't a simple module be written to remove all "$" characters from cells in the sheet? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| absolute & relative references | Excel Discussion (Misc queries) | |||
| Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
| Absolute / Relative References | Excel Programming | |||
| Check relative / absolute references | Excel Programming | |||
| Absolute vs. Relative Cell References | Excel Programming | |||
Threaded Mode
