Whenever I run the following macro, it changes the current value of the data validation list ("YES" or "NO") to the opposite if it is "True." What can I do so that after it is done, I still have the same values. Thanks!!!
If Sheets("Change Log").Range("B7") = "NO" Then
Sheets("Change Log").Range("B5:B6").Copy
Sheets("Change Log").Range("B16").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End If
Sheets("Change Log").Range("B7") = "YES"
If Sheets("Change Log").Range("C7") = "NO" Then
Sheets("Change Log").Range("C5:C6").Copy
Sheets("Change Log").Range("B18").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End If
Sheets("Change Log").Range("C7") = "YES"
Bookmarks