Hi,

This works apart from It puts up an OK box that you have to click for
each cell. This is a lot of clicking to clear 200+ cells. Any way to
change it so that it just runs right through?

Thanks,

S


--
scriblesvurt
------------------------------------------------------------------------
scriblesvurt's Profile: http://www.excelforum.com/member.php...o&userid=24399
View this thread: http://www.excelforum.com/showthread...hreadid=380010