Live Interactive Virtual LearningLive interactive virtual classes are available for our public scheduled courses as well as group or in-house training requests.
Experience training in the comfort of your home or office!
There are times you need to highlight duplicate data in your worksheet. This macro does the trick.
Application.ScreenUpdating = False
Rng = Selection.Rows.Count
For i = Rng To 1 Step -1
myCheck = ActiveCell
For j = 1 To i
If ActiveCell = myCheck Then
Selection.Font.Bold = True
Selection.Font.ColorIndex = 3
Application.ScreenUpdating = True