I have an IF function in VBA that has a mathematical formula in it:- (Cells(i3, 10).Value > 30)
The issue i'm having is that the values in column 10 are all alphanumeric. For example they're all " 1 - Hard", "2 - Moderate", "3 - Easy".
Is there anyway to make VBA only look at the number so when it's testing if the value is more than 30, it actually works?
Thanks
Aucun commentaire:
Enregistrer un commentaire