Got some Great help today on a project from a member here,I would like to change the range that it checks. Having no luck,so I'm doing something wrong.
Good Code
If Sheets("60 Circuits").Range("C8").Value <> "" Then
Sheets("Main").CommandButton6.BackColor = vbGreen
Else
Sheets("Main").CommandButton6.BackColor = RGB(224, 224, 224)
End If
Not working Code
If Sheets("60 Circuits").Range("C8:D37").Value <> "" Then
Sheets("Main").CommandButton6.BackColor = vbGreen
Else
Sheets("Main").CommandButton6.BackColor = RGB(224, 224, 224)
End If
Trying to get it to check any cell in that range?
Bookmarks