is there a way of having the below statement to state if there are duplicated have a messgae box state" Duplicates Found"
and if there are not
"No Duplicates Found"
![]()
Worksheets("Summary").Select ' Columns("Z:Z").Select Selection.FormatConditions.AddUniqueValues Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority Selection.FormatConditions(1).DupeUnique = xlDuplicate With Selection.FormatConditions(1).Font .Color = -16751204 .TintAndShade = 0 End With With Selection.FormatConditions(1).Interior .PatternColorIndex = xlAutomatic .Color = 10284031 .TintAndShade = 0 End With Selection.FormatConditions(1).StopIfTrue = False MsgBox "Done" End Sub
Bookmarks