View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
courtesio99[_8_] courtesio99[_8_] is offline
external usenet poster
 
Posts: 1
Default 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/