Hi all,

I am wondering if it is possible to search a column full of assorted values which is unsorted, and then return the closest value.

I have written a previous thread which was similar, but misleading, i feel this thread is more to the point.

Currently i use this code, but it only finds the closest highest value if the data is sorted in ascending order.

Dim myNum as Long
Dim cl as Range

' This code finds the closest highest value in column A in ascending order
Set cl = WorksheetFunction.Index(Range("A:A"), _
            WorksheetFunction.Match(myNum, Range("A:A"), 1))
Can anyone help?

Thanks,

Yappa