I have a routine that updates cell values conditionally based on other cell
values on the same sheet.
e.g.
sCopyRange = "D" & LTrim(Str(i))
If Left(Range(sCopyRange).Value, 3) = "QA " Then
SCopyRange1 = "L" & LTrim(Str(i))
If Len(Range(SCopyRange1).Value) 1 Then
Range(sCopyRange).Value = "Verified Fixed"
Else
Range(sCopyRange).Value = "Fixed"
End If
End If


This routine takes under a second in workbook1, but take 2 minutes+ using
the same data in another workbook2. The main difference is that workbook2
has a larger amount of macros and code, and data in other sheets, but as
stated above the data on the active sheet is identical. Can someone please
explain why this should be and what I can do about improving performance in
workbook2?