My question is how do I apply the solution? Where does this does this code
go? Any info would be greatly appreciated.[/QUOTE Wrote:


Hi there,
when you are in your workbook, press Alt & F11
You will then be in VB
at the top menu select insert, module
copy and paste your code in there
when you want to run your macro, press Alt& F8
your macro will show up and then select it and click run


Or you can create a button and assign your macro to it


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=521949