Thanks for the advice. I edited the post and attached a dummy workbook, I used before and after worksheets and I highlighted the cell I'm having issues with.