Hi! I have a code that finds the duplicates of column A and merges some columns on the same row according to how many duplicates are in the column A.

When I run the code pressing F8 everything works marvelous but when I run it as it's supposed to run (F5) then it just won't merge anything.

Can anyone help me, please? This is driving me nuts and it's the last thing I need to fix for presenting a project to my boss


Application.DisplayAlerts = False
    With Application.WorksheetFunction
    Dim count As Integer
        For i = 4 To 40
            If Sheet3.Range("A" & i) = Sheet3.Range("A" & i).Offset(1, 0) And Sheet3.Range("A" & i) <> "" Then
                count = .CountIf(Sheet3.Range("A4:A44"), Sheet3.Range("A" & i))
                Sheet3.Range("A" & i & ":" & "A" & i + count - 1).Select
                Selection.Merge
                Sheet3.Range("N" & i & ":" & "N" & i + count - 1).Select
                Selection.Merge
                Sheet3.Range("B" & i & ":" & "B" & i + count - 1).Select
                Selection.Merge
                Sheet3.Range("C" & i & ":" & "C" & i + count - 1).Select
                Selection.Merge
                Sheet3.Range("D" & i & ":" & "D" & i + count - 1).Select
                Selection.Merge
                Sheet3.Range("E" & i & ":" & "E" & i + count - 1).Select
                Selection.Merge
                Sheet3.Range("F" & i & ":" & "F" & i + count - 1).Select
                Selection.Merge
                Sheet3.Range("G" & i & ":" & "G" & i + count - 1).Select
                Selection.Merge
                Sheet3.Range("H" & i & ":" & "H" & i + count - 1).Select
                Selection.Merge
                Sheet3.Range("I" & i & ":" & "I" & i + count - 1).Select
                Selection.Merge
                Sheet3.Range("J" & i & ":" & "J" & i + count - 1).Select
                Selection.Merge
                Sheet3.Range("M" & i & ":" & "M" & i + count - 1).Select
                Selection.Merge
                i = i + count - 1
            End If
        Next
    End With
Thanks for reading ^^