by =?Utf-8?B?U3RldmUgTWNEb25hbGQ=?= <Steve McDonald@[EMAIL PROTECTED]
May 19, 2008 at 07:14 AM
I'm having a similar problem with a workbook that was working fine with
Excel
2003. I have a simple macro that inserts a new line at the top of a list
and
copies the formulae from the previous line (I'm quite lazy!):
Sub AddRow()
' Macro recorded 23/03/2006 by dvscm
'
Rows("3:3").Select
Selection.Copy
Selection.Insert ****ft:=xlDown
Application.CutCopyMode = False
Range("A3:E3,l3:m3").Select
Selection.ClearContents
Range("A3").Select
End Sub
Now that I'm using Excel 2007, this simple operation takes 17 seconds to
complete. It appears that the insert row takes all the time, even though
the
data only covers the range A1:M92 - not exactly a large amount.
Can you suggest anything that I can do to speed this up as I've had to
resort to anything other than Excel (eg paper and pen!)?
Thanks,
Steve