Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Have code check cell contents on edit. | Excel Worksheet Functions | |||
check for repetition of cell contents | Excel Worksheet Functions | |||
Check cell contents before print | Setting up and Configuration of Excel | |||
Fussy check of cell contents | Excel Discussion (Misc queries) | |||
IF statement to check cell contents | Excel Worksheet Functions |