BenRichards
New Member
- Joined
- Apr 7, 2014
- Messages
- 41
Hi,
I get the error "Object required," and debug highlights the bolded line. What is wrong with this bit of code?
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("T82:AA457")) Is Nothing And ActiveSheet.Range("V80").Value = "-" Then
Application.EnableEvents = False
ActiveSheet.Range("T82:AA457").Value = ""
Application.EnableEvents = True
End If
Thanks for your help!
End Sub
I get the error "Object required," and debug highlights the bolded line. What is wrong with this bit of code?
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("T82:AA457")) Is Nothing And ActiveSheet.Range("V80").Value = "-" Then
Application.EnableEvents = False
ActiveSheet.Range("T82:AA457").Value = ""
Application.EnableEvents = True
End If
Thanks for your help!
End Sub
Last edited: