I would suggest using VBA button to add code tags for posting code vba
or vb code.

You might try setting the calculation mode to manual and turn off
screen updating. I posted some speedup routines in this link. 'VBA
Express : Excel - Speed Up Code'
(http://vbaexpress.com/kb/getarticle.php?kb_id=1035)


--
Kenneth Hobson
------------------------------------------------------------------------
Kenneth Hobson's Profile: http://www.thecodecage.com/forumz/member.php?userid=413
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=106158