RedRooster
New Member
- Joined
- Mar 23, 2023
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
New at this. I have 4 sheets in a workbook that all contain the exact macro code. The macro code it to identify and highlight yellow all cells on each of the sheets when a change takes place. One of the sheets works fine all the time. The other 3 initially work but for some reason start to throw a 104 Application-defined or Object-defined error. How do I get the 3 not working to work along with the one that does work?
Sub Worksheet_Change(ByVal Target As Range)
Range(Target.Address).Interior.Color = RGB(250, 250, 0)
End Sub
Sub Worksheet_Change(ByVal Target As Range)
Range(Target.Address).Interior.Color = RGB(250, 250, 0)
End Sub