How to Prevent Paste on Data Validation cell in Microsoft Excel? Solved via VBA MACRO Private Sub Worksheet_Change(ByVal Target As Range) Dim xValue As String Dim xCheck1 As String Dim xCheck2 As String If Target.Count > 1 Then Exit Sub End If Application.EnableEvents = False xValue = Target.Value On Error Resume Next xCheck1 = Target.Validation.InCellDropdown On Error GoTo 0 Application.Undo On Error Resume Next xCheck2 = Target.Validation.InCellDropdown On Error GoTo 0 If xCheck1 = xCheck2 The

42K views · 636 reactions | 푬풙풄풆풍 푻utorial: HOW TO USE COPY > PASTE >...

209K views · 473 reactions | Josh really said copy paste  | The Herberts | Facebook