Perhaps one of our VBA Experts will be able to helps you but be sure that best way to describe your pronlem is to attach a small sample workbook.