slow sorting worksheets
 

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

--
Message posted from http://www.ExcelForum.com

slow sorting worksheets
 

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

--
Regards,
Tom Ogilvy

"crew3407 " wrote in message
...
Hi all,

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

i have a macro that automatically adds a new client worksheet and puts
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 was
Neil, Neil would be placed in front of Abby. After I've added all the
clients, I want to sort the worksheets.

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

is there some memory issue with this?

Thanks


---
Message posted from http://www.ExcelForum.com/

slow sorting worksheets
 

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

--
Message posted from http://www.ExcelForum.com

slow sorting worksheets
 

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!

--
Message posted from http://www.ExcelForum.com