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/

.