compare 2 different numbers and copy the last 3 digits.

Originally Posted by Marcol

Both seem to work for me

Go with Jindon, it's shorter.

great
now I need it in VBA

I'll tray my self