Re: slow sorting worksheets

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 05/06/04 

Date: Wed, 5 May 2004 22:49:38 -0400

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 >" <<crew3407.15sq3e@excelforum-nospam.com> wrote in message
news:crew3407.15sq3e@excelforum-nospam.com...
> Hi all,
>
> One more time today.  I have tried all the different work*** 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 work*** 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/
>
Quantcast