COLLUMNS COUNT IN EXCEL 2010 TAKES A VERY LONG TIME
Posted on 2011-09-18
I have an Excel 2010 file which was created by "dlmille" and given to me in order to sort columns and count blocks. See related post "CREATE THICK BOX BORDER ON COLUMNS FOUND IN MACRO SEARCH".
It works just fine but I have one slight problem and a few additions to help me do my work a little faster.
1.The atached file "Count 1" takes approximately 4 minutes to sort the contents which does not seem too bad but when doing 20 or more in a day it adds up.
The contents of this file only go to line 1,024. I have had instances where the file content when as far as line 45,000. This one took almost 2 hours to sort and that's really bogging me down.
So I was wondering if there is any way to speed up the process.
I have an i7 Q820 processor with 8 Gigs of RAM and Windows 7 Ultimate so I don't really understand why this is taking so long. If the process can't be speeded up within the Excel file maybe there is something I could do in Windows to speed it up. I really don't know what to do but I really need help with this.
2.Sometimes in the final count, some of the columns wind up being just 1 or 2 rows high instead of 3 rows high (See "Count 2" file attached). In this case I can't sort because the way the count was setup, Excel is looking for columns of 3 rows high and when there are rows which are smaller it just gets all messed up. Would it be possible to get Excel to delete the columns which are not 3 rows high as I do not need these when they happen to be in the final count.
3. It also really would be helpful if I could get the columns which are all "white" to have a thick border when I need to only. I press CTRL B to do the count and also to put a thick border around the Yellow blocks, if it could be arranged so I press CTRL C to but a think border around the white columns it would be great. That way I could have a border around the white columns but only when needed as I do not need the border around the white collumns all the time.
I wish I could of forseen this when I was geting help with this previously but it's only by working with it that I noticed this.