MissingInAction
Board Regular
- Joined
- Sep 20, 2019
- Messages
- 85
- Office Version
- 365
- Platform
- Windows
Hi. I'm trying to create a workbook that the user must send back to me after making changes. I am using a VBA script I found online to highlight the changes made. This is the code:
However, this has some limitations. If I press delete on a cell, it does not highlight. Autofilling or making changes to multiple cells at once (copy/paste) also gives a "Type mismatch" error. It seems the script/code gets confused and does not know what to do. How can I overcome these limitations?
My VBA knowledge is very limited, so any help is appreciated.
Thank you
VBA Code:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Target.Value <> "" Then
Target.Interior.ColorIndex = 6
End If
End Sub
My VBA knowledge is very limited, so any help is appreciated.
Thank you
Last edited: