Suggest you post (upload) a sample workbook so that precise code can be written for you. Click on Go Advanced Button when you reply and follow the wizard.