Find Largest Number In String

I am trying to create a macro that will determine if a number in each cell in a range is greater than 25. However some of the data I am working with has a "-" in the cell to separate multiple numbers so I would need the macro to take the largest number from within the cell to determine if it is greater than 25. Essentially the cells in the range would look like:

12
28
0
1-24
4
6-33

This is the module that I was using for a similar task, but is no longer accurate. I appreciate any help.

Please Login or Register  to view this content.

Do you mean like this?
Otherwise need to see your data and the result that you want

Please Login or Register  to view this content.

Worked perfectly thank you very much.