Hi, I have a range of numbers in cells D4 to D15 as such:-

135, 133, 117, 82, INJ, Sick, 129, 112, 92, 85, 111

Is there a way using VBA that I can analyse the values, ignore and highlight the cells with INJ, Sick or any other text, and return a total for the highest 8 values?

Thanks