Hi again AlvaroSiza - tried your macro and it worked wonderfully. Thanks again. I'm wondering how to make the macro run on only the active worksheet. I tried editing the macro with a few different activesheet. commands but nothing I've tried is working. Wonder if you would provide some direction. Many thanks!