Yes I have tried those see the thing is after the sort is done and the
macro is finished I need the calculations on for the lookups to
populate. I don't want the people using this to have to hit a button to
update. In the beginning of the macro the calculations get turned off,
but at the end I turn them back on. That is when the autocalculations
start and it adds 4-5 seconds but some times it plays tricks with the
sort. I don't want the calculations on at all for the sort, but I need
it on for the lookups.


--
robertjtucker
------------------------------------------------------------------------
robertjtucker's Profile: http://www.excelforum.com/member.php...o&userid=21805
View this thread: http://www.excelforum.com/showthread...hreadid=374002