vba to check cell contents
 

In my vba routine I want to check the cell contents to see if it's NOT a
numerical value. And I'm considering a blank cell to be non-numeric.

Thanks.

vba to check cell contents
 

if application.isnumber(mycell.value)) then
it's a number the way excel sees it!


if isnumeric(mycell.value) then
is far less stringent than the =isnumber() excel function.
If it looks like it could be a number, it's numeric.

Steve wrote:

In my vba routine I want to check the cell contents to see if it's NOT a
numerical value. And I'm considering a blank cell to be non-numeric.

Thanks.

--

Dave Peterson

vba to check cell contents
 

hi
work something like this into your routine....
Sub whatisit()
Dim r As Range
Set r = Range("C10")
If WorksheetFunction.IsNumber(r) Then
MsgBox "is number"
Else
MsgBox "is not number"
End If
End Sub

regards
FSt1

"Steve" wrote:

In my vba routine I want to check the cell contents to see if it's NOT a
numerical value. And I'm considering a blank cell to be non-numeric.

Thanks.