| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replacing values in formulae with links
Or, you could try converting the links to text first by Edit/Replace
Find = Replace With %% Then Edit/Replace the cell references you want and convert the text back to formulas with Find %% Replace With = That didn't really help, but now I know that just _one_ of these sheets has 1600+ formulae and 6000+ occurences of $978 However, the problem still occurs when I do the last step. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing formulae links | Excel Programming | |||
| Macro replacing links | Excel Discussion (Misc queries) | |||
| Replacing Formulae With Values.....Continuation | Excel Programming | |||
| Another Question Concerning Replacing Formulae With Values ! | Excel Programming | |||
| Replacing links with values | Excel Programming | |||
Threaded Mode
