In this line of code only the bold brackets are colored: ThisWorkbook.Sheets("Index").Cells**(**1,ThisWorkbook.Sheets("Index").Cells**(**1, Columns.Count).End**(**xlToLeft).Column+1).Value Thanks for your release anyway :+1: