Switch numbers using userform

Hi, I'm changing values in a range, similar to Find and Replace, using a userform, so it can be done all at once. The macro can do this. Arrays are used to compare.

Wanted to extend as follows:
Test if a New number is already in Existing range, such as in first image.
The exception is that if numbers are switched, this is OK, such as in second and third image.


Untitled.png

Please Login or Register  to view this content.