Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Mac > Excel Office for Mac > Re: sslloooooow...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 5 of 7 Topic 5598 of 6196
Post > Topic >>

Re: sslloooooow Excel 2008.

by Bob Greenblatt <bob@[EMAIL PROTECTED] > May 19, 2008 at 03:17 PM

On 5/19/08 10:14 AM, in article
3FB58C9A-7A0F-4D29-B9EA-D8C1FC6321D0@[EMAIL PROTECTED]
 "Steve McDonald"
<Steve
McDonald@[EMAIL PROTECTED]
> wrote:

> 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
Well you called it Excel 2008 which is a Macintosh version. I think you
really mean Excel 2007. I'd try a few things. 1)If you can avoid it NEVER
select anything in VBA. And 2) Turn off screen refresh.  Your macro ought
to
look like:
> Sub AddRow()
> ' Macro recorded 23/03/2006 by dvscm
> ' and modified by bob Greenblatt
>     Application.screenupdating=false
>     with Rows("3:3")
>        .copy
>        .Insert ****ft:=xldown
>     end with
>     Range("A3:E3,l3:m3").clearcontents
>     Range("A3").Select
> End Sub

See if this makes any difference.
-- 
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom
 




 7 Posts in Topic:
sslloooooow Excel 2008.
"john.e.palmer@[EMAI  2008-05-06 13:57:55 
Re: sslloooooow Excel 2008.
Pat McMillan <patmcmil  2008-05-08 10:36:42 
Re: sslloooooow Excel 2008.
tfrank@[EMAIL PROTECTED]   2008-05-09 17:55:25 
RE: sslloooooow Excel 2008.
=?Utf-8?B?U3RldmUgTWNEb25  2008-05-19 07:14:01 
Re: sslloooooow Excel 2008.
Bob Greenblatt <bob@[E  2008-05-19 15:17:59 
Re: sslloooooow Excel 2008.
=?Utf-8?B?U3RldmUgTWNEb25  2008-05-19 12:30:02 
Re: sslloooooow Excel 2008.
ric49@[EMAIL PROTECTED]   2008-05-26 06:08:44 

Post A Reply:
  Go here to Signup

AddThis Feed Button


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

Contact
tan12V112 Fri Aug 29 12:30:31 CDT 2008.