Yes my code was tested & was working. As everyone else has said, post a sample workbook that shows the error. Change the data to gobbledegook if it's sensitive