Working with ranges

Hi to all.
I'm changing the formulas using a macro, but this process is very slow (around 4 mins). My ranges are not huge, lets say "B8:B91,D8:D91,F8:F91"
and I'm using the REPLACE command to change this formulas:

Please Login or Register  to view this content.

But if I use:

Please Login or Register  to view this content.

"seems" to be more fast.

I'm using too

Please Login or Register  to view this content.

How can I improve the speed of this process?

Hi this took 0.06 seconds for me, i didnt turn off screen updating or calculation to manual ...i just ran it!

Please Login or Register  to view this content.

regards,
Simon

Ok, my formulas contain links or references to another sheets. Then my cells look like:

Please Login or Register  to view this content.

Then, I want to replace $A$39 by $D$39 using this REPLACE. I used this macro in another pc without the source files, and it is SO FAST. But, in a pc with these files (File -2007.xls and File -2006.xls), takes around 4 minutes.

I dont know how to improve this. 4 minutes is to much for a replace.

Gtorres you should have stated your problem fully! It depends on the size and complexity of the files its dealing with....best to open those workbooks them selves and run the code in them!

Regards,
Simon