It would help if you could post your workbook. It will make troubleshooting problems and modifying the macro easier and faster.