Single threading hell... June 25. 2009

One needs to wonder why Excel isn't capable of multi threading VB macros. One such macro is used to remove rows in a sheet that has a corresponding row in another sheet. I'm sitting here waiting for almost 30 minutes for it to remove 26K rows. How slow can that be on a 2.2GHz proc????
Daniel Chee  Thursday, June 25. 2009 @ 23:08
3 Comments Link to entry

Trackbacks
Trackback specific URI for this entry

No Trackbacks

Comments
Display comments as (Linear | Threaded)

I once wrote a macro to find from a list, satellite earth stations closest to a terrestrial tower. Calculate the look angle and sort by distance. That macro ran overnight in the office. Yeah a lot of good fun.

By the way you probably already know this but if you turn off visual updating when you run the macro it runs a hell lot faster.
#1 conrad on 2009-06-28 08:48 (Reply)
How'd you turn off visual updating?

I'm not much a MS Office user.
#1.1 Daniel on 2009-06-28 16:13 (Reply)
Just add a couple of lines in the macro

Application.ScreenUpdating = False

where you want it to stop updating and

Application.ScreenUpdating = True

when you want it to resume updating.

Great for when you have the macro switching between sheets or windows.
#2 conrad on 2009-06-28 23:37 (Reply)

Add Comment

Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
Standard emoticons like :-) and ;-) are converted to images.
E-Mail addresses will not be displayed and will only be used for E-Mail notifications.

To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly.
CAPTCHA

You can use [geshi lang=lang_name [,ln={y|n}]][/geshi] tags to embed source code snippets.