One tip for vastly increasing speed is to put


Code
-------------------
Application.ScreenUpdating=False

...CODE...

Application.ScreenUpdating=Tru
-------------------


You should see a significant increase as nothing is being written t
the screen whilst this is taking place. If it is for an end user
think about adding:


Code
-------------------
Application.StatusBar = "Processing...
-------------------

or something similar

--
MartinShor

Software Teste
-----------------------------------------------------------------------
MartinShort's Profile: http://www.excelforum.com/member.php...fo&userid=2203
View this thread: http://www.excelforum.com/showthread.php?threadid=54866