Ok. I'm with this...sort of. The next question is, where does it go? Does it go in the code corresponding to a commandbutton_click event or does it establish parameters during workbook opening, or some other event? If I am understanding the code correctly it is looking for information already on the clipboard, it is not copying info to the clipboard and then modifying it. Is that correct?

DJams