Help with "target.value" in VBA

[MissingInAction]

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:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
    If Target.Value <> "" Then
        Target.Interior.ColorIndex = 6
    End If
End Sub

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

 

[Fluff]

How about

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
   Target.Interior.ColorIndex = 6
End Sub

 

[MissingInAction]

I was thinking I'm going to need some form of "else" statement, but that works perfectly. Thank you very much.

 

[Fluff]

You're welcome & thanks for the feedback.