I have this disable save code but how can i save this code into the workbook?
This code is only deleting what the duplicate entry is, how can i make it to delete the row?
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 And Len(Target.Value) > 0 Then
If Evaluate("Countif(A:A," & Target.Address & ")") > 1 Then
MsgBox Target.Value & " is a duplicate entry. It will be removed.", vbExclamation, "Data Entry Editor"
Hi everyone, i would like to have something where if a record that allready exists in Column E, an error message is displayed "Duplicate Record"
[h=2]Hello, i have inserted a listbox on sheet1. In column A multiple rows have data A, B, C. I would like to have the number of rows that have A, B and C listed in the Listbox