Formulas usually work only in a specific cell because the adjust addresses
depending on where they are used. Are the formulas all exactly
the same ?

Can you give an example of what you have and what you want.

Look at the Replace function in VBE HELP.

Also Ctrl+H replace in the worksheet will also work on formulas.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"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