Value not equal to another value then zero

Please Login or Register  to view this content.

working : if .value = .value in another sheet then .value = 1
code : if .value <> .value in another sheet then .value = 0 (help required by using else)

if requirement is true .value = 1
else
.value should be 0 (zero).

thanks CK76.....

small correction in my for loop : For x = 2 To y