slow sorting worksheets

C

crew3407

Hi all,

One more time today. I have tried all the different worksheet sort
that have been mentioned, but my sheets are getting sorted extremel
slowly most of the time, and sometimes relatively quickly.

i have a macro that automatically adds a new client worksheet and put
his/her name in the various lists that i have, alpha, value, so on.
when i add my sheets, i add them in the front of all the client sheets
So if it was alphabetized Abby, Grace, Tom and the new client name wa
Neil, Neil would be placed in front of Abby. After I've added all th
clients, I want to sort the worksheets.

herein lies the problem. I think this is the problem, but after i ru
my macro and try to sort, the sort procedure crawls. however, if
just mess up the order of the sheets randomly myself without having ru
my add in client macro, then the sorter works fine.

is there some memory issue with this?

Thank
 
T

Tom Ogilvy

If your adding a single sheet, and your sheets are already sorted, why not
place it where it should be. Put Neil before Tom.
 
C

crew3407

Tom,

Well, I'll be adding in multiple sheets when i do this, and I have t
enter in data on each of these sheets and double check to make sur
those values are transferred over to other sheets which are near th
beginning.

I guess if the sort worksheets code would run faster if I just place
the new worksheet where it belonged in the first place, that would b
fine too. How would you write that type of code?

Also, do you have an idea of what's going on with why the worksheet
are getting sorted slowly after i run a previous macro?

Thank
 
S

Simon Lloyd

Well Crew,

If its any consolation i have a work book that on auto close runs
sheets update by selecting a range and then offsetting the results t
produce dates in other cells on the same sheet its 20 sheets and abou
5.5 meg and takes 5 mins to update! so if yours is just slow coun
yourself lucky!

Simon

(p.s. i know this wasnt any help but just had to let you know whe
you're lucky!
 
Top