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