Post your sample workbook. Maybe a more helpful code can be written.