The script below works perfect, except I need it to clear contents on worksheets labeled "Monday, Tuesday, Wednesday, Thursday, Friday" when cell (U2) on "Monday" is changed. HELP!!!


Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("u2")) Is Nothing Then Exit Sub
[H8:O27,H30:O41,U30:U41].ClearContents
End Sub