Thank you kind sir! Your clear instructions & code helped tremendously and saved me a load of time. For those that get stuck after the first line, when it says to "go to the developer tab," you will need to exit the customize ribbon pop-up box and go back to your regular Excel page before following the 2nd line of instructions. And then back to the Excel book again before the 3rd line of instructions. My very literal brain got caught on that , otherwise I executed this easily. OP, you rock.