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!
|