If edit=replace would work doing it manually, then you can do the same with
code.

--
Regards,
Tom Ogilvy

"Vijay" wrote in message
...

I have a workbook with 15 worksheets in it. I need to go through all the
cells in the entire workbook and replace certain formulas with values and
some with other formulas. I am currently doing this task using VB 6.0 by
looping through all the cells in all the worksheets of the workbook, but
this process goes on forever and ever and I am yet to see if finish. Is
there a quicker and easier way to accomplish this?

Thanks in advance.

- Vijay