View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Conceptor[_2_] Conceptor[_2_] is offline
external usenet poster
 
Posts: 13
Default 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.