Optimize code

**miso.dca** · 02-08-2011, 01:43 PM

Hello,
I have this code

Please Login or Register  to view this content.

it works, but it's really slow ... I have more than 1000 rows and this code is really really slow ... it is possible to change it and macro will be faster? thanks for any help !

**jeffreybrown** · 02-08-2011, 01:58 PM

For starters you can try and put

Please Login or Register  to view this content.

at the beginning of the sub

and at the end

Please Login or Register  to view this content.

Also, you do not need to select an object to work with it

Not tested but you might be able to change it all to

Please Login or Register  to view this content.

**miso.dca** · 02-08-2011, 02:06 PM

thank you jeffrey

I have disabled screen updating - it is faster of course, but this :

Please Login or Register  to view this content.

doesnt work - excel writes "Object doesnt support this property or method" - what can I do to repair it?

**jeffreybrown** · 02-08-2011, 02:41 PM

Take off the .paste

**miso.dca** · 02-08-2011, 02:50 PM

it works ! even faster

but still not so fast as I think it will be

**jeffreybrown** · 02-08-2011, 03:16 PM

Maybe you can find some other ideas here...

http://blogs.office.com/b/microsoft-...practices.aspx

http://www.decisionmodels.com/

http://msdn.microsoft.com/en-us/library/aa730921.aspx

**miso.dca** · 02-08-2011, 03:35 PM

thank you ! i will check it

Optimize code

LinkBack

Thread Tools

Rate This Thread

Display

Optimize code

Re: how to optimalize code?

Re: how to optimalize code?

Re: how to optimalize code?

Re: how to optimalize code?

Re: how to optimalize code?

Re: how to optimalize code?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions