We have an Excel VBA macro that takes 9 minutes to complete on one PC while most run the macro in about 30 seconds. I can get to this section of the macro in the problem PC in about 19 seconds but executing the .Clear takes over 2 minutes.
Note that this macro is a carryover from 2001 and we've had to modify it to run on the newer versions of Excel. All Computers are using Excel 2013 but the version varies slightly (15.0.4753.1000 vs. 15.0.4745.1000)
' Clear error flags
Range(Cells(2, 1), Cells(sze, 1)).Clear
sze = 238