Everytime I click on my macros button, I get a Run-time error '9': Subscript out of range message. I click on debug, it highlights the script: Private Sub Worksheet_Calculate()
If Sheets("Checklist").Range("a62") = True Then
Sheets("Contra_submittal").Visible = True <---Highlighted
Else
Sheets("Contra_submittal").Visible = False
End If
End Sub Can anyone help me how to fix this?
If Sheets("Checklist").Range("a62") = True Then
Sheets("Contra_submittal").Visible = True <---Highlighted
Else
Sheets("Contra_submittal").Visible = False
End If
End Sub Can anyone help me how to fix this?