Reply to thread

Message: [QUOTE="mudraker, post: 3295995"] Check your checkbox name. I have been able to replicate your error message by calling for the value of a checkbox that did not exist on my test sheet. To simplify your code I suggest you modify it as If Sheets("Step 4").CheckBox43.Value = True Then Sheets("Step 6").Range("C15").Interior.ColorIndex = 2 Sheets("Step 6").Range("G15").Interior.ColorIndex = 2 Sheets("Step 6").Range("I15").Interior.ColorIndex = 2 Else Sheets("Step 6").Range("C15").Interior.ColorIndex = 42 Sheets("Step 6").Range("G15").Interior.ColorIndex = 42 Sheets("Step 6").Range("I15").ColorIndex = 42 End If [/QUOTE]