Thank you, Ben. I was thinking of using a macro so that I could learn how to do it that way and then I wanted to convert the macro to VBA that way I could see how to do it in both. Please, Ben what would be the rest of the code you gave, the 'do something' part. Would it be something like...