Hi Below code gives me the wrong result.
I have numbers format as general, (Have to be like this) and without and decimal and all zeroes also.

If i run example for number 73, it will find all who have this number inside, example 1732 and so on. Its the same with other numbers.
95420 it will also find 595420 or also 5954206.
I need it to only find the numbers i search for, but without change the format of how they are put in.

My code are like this now. It compare in sheet 2 A1 and B1 with numbers i paste into sheet 3 A1 down.

Please have a look.

Thanks in advance

Sincerel

Abjac



Please Login or Register  to view this content.