Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
if isnumeric(mydata) then
Range("M1").Value = mydata else ' mydata contains non numeric information ' do nothing End if -- Regards, Tom Ogilvy "Tim" wrote in message ... How would i do that. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Validation of UK VAT Number | Excel Worksheet Functions | |||
custom validation with number & text | New Users to Excel | |||
custom validation number and text | Excel Discussion (Misc queries) | |||
validation for phone number | Excel Discussion (Misc queries) | |||
attach a label to number, like validation but follows the number | Excel Worksheet Functions |