Recalculating Links
 

I need to use Find and Replace (Excel 2002) to modify a lot of formulas. Is
there a way in VBA to disable the recalculation of each cell after the
formula is updated? It's taking forever!

I tried the follwoing but it does not work:

Sub Macro1()
Application.Calculation = xlManualCalculation
Application.ScreenUpdating = False
Application.AskToUpdateLinks = False

Cells.Replace What:="ALL'!", Replacement:="ATG'!", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False
Application.ScreenUpdating = True
End Sub

Thanks!

Recalculating Links
 

Opening the source file(s) would make it much faster

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup