I'm trying to out a condition whereby if my sub produces a "Positive result" then that row gets locked.
I'm working with Column B in range of ("B8:B66"):
x = ActiveSheet.Range("B8:B66")
found = True
For Each cell In Range("B8:B66").Cells
If cell.Value = "X" Then