Exit loop bIsNumeric = False Exit For End If Next cell If bIsNumeric = True Then 'All values in your range are numeric '**PLACE CODE HERE** MsgBox 'All values are numeric' Else 'There are non-numeric values in your range '**PLACE CODE HERE** MsgBox 'There are non-numeric values in your range' End If End Sub Sub IsNumericRange () Dim cell As Range Dim bIsNumeric As Boolean bIsNumeric = True For Each cell In Range ( 'A1:B5' ) If IsNumeric ( cell ) = False Then 'Non-numeric value found. IsNumeric Examples Check if a Cell is a Number I’ll show you a macro that does that in the IsNumeric Examples section.īecause IsNumeric returns True or False, it’s a great expression to include inside If Statements. You’ll have to do that with a loop of your own, like a For Each loop. The IsNumeric function won’t loop through each cell in your range and check whether each of them are numeric. It won’t choke up on any of these, but that doesn’t mean it’ll give you the answer you want.įor example, if you enter a range, like Range('A1:B5'), into an IsNumeric expression, it will always return False even if all the values in the range ARE numeric. The complicated jargon isn’t necessary.Īll you need to know is that IsNumeric can pretty much evaluate anything. The syntax for the IsNumeric function can’t get any simpler:Īs you can see, IsNumeric accepts one argument: an expression of the Variant Data Type.

If it’s not a number, it will return False.If IsNumeric thinks your expression is a number, it will return a value of True.This isn’t the first time you’ve seen me use IsNumeric in my VBA macros, but in this tutorial I’ll explain how it’s used and what it’s good for. The IsNumeric VBA function is a counterpart to the Excel ISNUMBER function, but the expressions don’t always produce the same results. The IsNumeric VBA function checks if a cell is a number and expresses the answer as a Logical Boolean ( True or False).

Visual basic for excel cells function