Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check for number
How do I check whether a certain cell has a number in it in code?
For example, i know Count(A1) gives 1 if cell A1 contains a valid number instead of text. How do I do that in code? I did the following but could not work: If Count(Cell(1,1))0 Then ... End If --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check for number
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check for number
no.. wat i mean is how to check that a number is entered in cell A1
instead of text. --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check for number
if ISNUMERIC(cell(x,y).value) then
Patrick Molloy Microsoft Excel MVP -----Original Message----- How do I check whether a certain cell has a number in it in code? For example, i know Count(A1) gives 1 if cell A1 contains a valid number instead of text. How do I do that in code? I did the following but could not work: If Count(Cell(1,1))0 Then ... End If --- Message posted from http://www.ExcelForum.com/ . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check for number
Hi bdcrisp!
Something like: If IsNumeric(Range("b1")) Then Range("c1") = "You have a number" -- Regards Norman Harker MVP (Excel) Sydney, Australia Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "courtesio99" wrote in message ... no.. wat i mean is how to check that a number is entered in cell A1 instead of text. --- Message posted from http://www.ExcelForum.com/ |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check for number
if vartype(cells(1,1).value) = vbString then msgbox "It's a string"
otherwise its a number --- Message posted from http://www.ExcelForum.com/ |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check for number
Hi courtesio99,
IsNumeric function may can be used. Note:Assume 3 has been inputted in A1 Cell. Nevertheless the A1 cel has been formatted as string, IsNumeric function returns TRUE. Code ------------------- If IsNumeric([A1]) Then MsgBox "It's a number" ------------------- -- Message posted from http://www.ExcelForum.com |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check for number
If you may have a containing a text value that looks like a number (like
'54--leading apostrophe), you can use the worksheet function: if application.isnumber(range("a1").value) then This'll also dump empty cells. if isnumeric(range("a1").value) then will show (empty) as numeric. courtesio99 wrote: How do I check whether a certain cell has a number in it in code? For example, i know Count(A1) gives 1 if cell A1 contains a valid number instead of text. How do I do that in code? I did the following but could not work: If Count(Cell(1,1))0 Then .. End If --- Message posted from http://www.ExcelForum.com/ -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check number within a range | Excel Worksheet Functions | |||
How do I hide the Check Box number? | Excel Worksheet Functions | |||
how do i check if a number is repeating | Excel Discussion (Misc queries) | |||
how do I check if known number is in array | Excel Discussion (Misc queries) | |||
check percentage or whole number | Setting up and Configuration of Excel |