| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
checking numbers in VBA
Ian,
Isnumeric returns TRUE for a blank cell so try MsgBox Range("A1").Value < "" And IsNumeric(Range("A1").Value) Which would return TRUE for a number Mike "Ian" wrote: how do I check if a variable is numeric in VBA for Excel, I've tried various combinations such as Isnu, Is Numeric etc but nothing seems to work unless I have my syntax wrong |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for checking duplicate numbers | Excel Discussion (Misc queries) | |||
| Checking Lotto numbers | Excel Worksheet Functions | |||
| Checking numbers across various sheets | Excel Worksheet Functions | |||
| Checking crossword numbers | Excel Discussion (Misc queries) | |||
| Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
Threaded Mode
