Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace sheet formulas with value
Hi,
I am trying to replace every sheet cells that contains a occurence of a specific formula with its returned value. If I would want to parse all cells that contains an occurence of my formula, how could I do it (short of parsing every single cells and doing a mid() to find out if there is a formula inside or not)? Is there some active cell collection Excel gives me access to or something like that? Thanks, C. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Freeze Formulas - Replace Worksheet | Excel Discussion (Misc queries) | |||
Replace data from sheet 2 into sheet 1 | Excel Discussion (Misc queries) | |||
The 'Look in' box for the 'Replace...' has only the 'Formulas' | Excel Discussion (Misc queries) | |||
Formula help! Find and replace in formulas | Excel Discussion (Misc queries) | |||
Search - replace NOT in formulas | Excel Worksheet Functions |