It would help if you could identify which line of the code the macro is
failing on. To do this, hit debug when you get the error and look for
the line that's highlighted in yellow.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=562323