This is the code
Sub IdentifyBlanksinDataValidation()
On Error GoTo NoBlank
Range("d6:e6").SpecialCells(xlCellTypeSameValidation).SpecialCells(xlCellTypeBlanks).Select
MsgBox "CA NAME cannot be blank", vbCritical
Range("d17").SpecialCells(xlCellTypeSameValidation).SpecialCells(xlCellTypeBlanks).Select
MsgBox "Process Type cannot be blank", vbCritical
Range("d18").SpecialCells(xlCellTypeSameValidation).SpecialCells(xlCellTypeBlanks).Select
MsgBox "Sub Type cannot be blank", vbCritical
Range("d20").SpecialCells(xlCellTypeSameValidation).SpecialCells(xlCellTypeBlanks).Select
MsgBox "Product/Specific Type cannot be blank", vbCritical
Exit Sub
NoBlank:
' Range("S2:AF2").Select
Selection.Copy
Sheets("Raw_Data").Select
Range("A5").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Rows("5:5").Select
Application.CutCopyMode = False
Selection.Insert Shift:=xlDown
Sheets("Tracker").Select
Range("D10:D11").Select
Selection.ClearContents
Selection.ClearContents
Range("D13:D15").Select
Selection.ClearContents
Range("D17:D20").Select
Selection.ClearContents
Range("B23:F32").Select
Selection.ClearContents
End Sub
RoyUK - Thanks for the link for wrapping codes
Bookmarks