Talk About Network

Google





Mac > Excel Office for Mac > RE: sslloooooow...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 5598 of 6965
Post > Topic >>

RE: sslloooooow Excel 2008.

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
 




 4 Posts in Topic:

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
localhost-V2008-12-19 Fri Jan 9 2:15:10 PST 2009.