Most of you will probably cringe when you see how I accomplished this, but the end justifies the means I guess.
I assume that code goes into some visual basics editor or something and I haven't a clue how to navigate that. Opened Visual Basics Editor but couldn't figure out how to get passed the blank screen. (no sheet of paper to work on).
So I recorded a macro, which turned out to be very simple to do, except it wouldn't work if I added worksheets or changed the name on the tab. So I clicked on edit, deleted the code (if that's the proper word) and pasted the code you wrote, Tom. That worked.
If there is an easier way to accomplish this that doesn't task your time too much, feel free to enlighten me. I do have one specific question though. Is the code in a Macro case-sensitive? Feel free to correct me if I'm using the wrong terms.