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/