ThrottleWorks
Excel Ninja
Code:
If OSht.Cells(i, MyCol (SumSht.Range("a1")).Column) <> "" And OSht.Cells(i, MyCol (SumSht.Range("a9")).Column).Value <> not a number Then
OSht.Cells(i, MyCol (SumSht.Range("a9")).Column).clear
End If
I am running an if condition in a range. I am facing problem while deciding the value is ‘Not Numeric.
Please see below example for your reference.
If Range A1 value = “Honda” (any text) and Range B1 value = 100 (any number) then do nothing
If Range A1 value = “Honda” (any text) and Range B1 value <> 100 (any number) then take action.
I tried Is Numeric but somehow it’s not working
Can someone please help me regarding how to write this condition