MACRO to check validation dropdowns left blank

Just checked your code, try this instead

Option Explicit

Sub IdentifyBlanksinDataValidation()
    Dim msg    As String
    On Error GoTo NoBlank
    If Application.WorksheetFunction.CountBlank(Range("d6:e6")) > 0 Then
        msg = "CA NAME cannot be blank"
        GoTo isblank
    End If
    If IsEmpty(Range("d17")) Then
        msg = "Process Type cannot be blank"
        GoTo isblank
    End If
    If IsEmpty(Range("d18")) Then
        msg = "Sub Type cannot be blank"
        GoTo isblank
    End If
    If IsEmpty(Range("d20")) Then
        msg = "Product/Specific Type cannot be blank"
        GoTo isblank
    End If
    Range("S2:AF2").Copy
    Sheets("Raw_Data").ange("A5").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
                                                                                        :=False, Transpose:=False
    Application.CutCopyMode = False
    Rows("5:5").Insert Shift:=xlDown
    Sheets("Tracker").Range("D10:D11,D13:D15,D17:D20,B23:F32").ClearContents
       
isblank:
    MsgBox msg, vbCritical, "Input missing"
    Exit Sub
End Sub