I am surprised. Usually these help with speed.
(need to apologize - you did have it in your posted code)

Usually I put all my code in the middle. So in your case it would be in the
Super Macro.

I have been playing with some alternate schemes but the calculation time
just climbs after about
5,000 lines.

Don't know if it could work, but try to sort on your column and delete rows.

Try this on a copy of your workbook. Do it manually first and see if it is
practical.

Another alternative is to look at filtering. With Advanced Filtering, you
can pull out unique records only.
This will still take some time, but am not sure of what it would be.

--
steveB

Remove "AYN" from email to respond
"KHashmi316" wrote
in message ...

STEVE BELL Wrote:
If you haven't already used these - they help speed up macros

Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
[ your code ]

Application.ScreenUpdating = True
Application.Calculation=xlCalculationAutomatic

--
steveB


Hmm... I tested this scheme by running a stop-watch on the code both
with and without the "speed-up" tweak. Using the "sped-up" method
actually took 10 seconds longer. " I'm not sure whether you meant
putting the tweak around just the DeleteDuplicateRows macro or the
"super" macro I'm using which calls on several sub-maros including
DeleteDuplicateRows. I tweaked the latter.

Thx for your reply and any further light you can shed.


--
KHashmi316


------------------------------------------------------------------------
KHashmi316's Profile:
http://www.excelforum.com/member.php...o&userid=10439
View this thread: http://www.excelforum.com/showthread...hreadid=376776