I have this code below that splits a spreadsheet into individual sections based on criteria in a certain column. It has 1000's of rows to go through and it is taking up to 8 minutes to run. It may be my computer but if there is any way of 'speeding' the code up it would be much appreciated if anyone could help.
Formula:
Please Login or Register to view this content.
See if this helps any,
Please Login or Register to view this content.
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
Seems to be running a bi quicker. The file size isn't helping my problem at all it would run quick enough had the file been smaller.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks