Hi,

I have a column of UNsorted numbers and need VBA to find the closest value
that is smaller than input value. So, if column contains: 89, 1, 5, 65, 14,
19, 9. and the given number x is 50, then the code should return 19.

The column cannot be sorted.

Thank you!
--
______
Regards,
Greg