Hi,

I have the same problem but was unable to use the code to match to my data set and i get an error "Complile error - Variable not found"
The error point to
Private Sub Worksheet_Change(ByVal Target As Range)

Please help.