View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
benb benb is offline
external usenet poster
 
Posts: 18
Default verifying data type

I want my code to look at the contents of a cell, and if the contents are not
a number (any string) execute one set of code. If the contents are a number,
skip over that code and continue on. I'm sure this can be easily done with
an If Then statement, but I don't know how to test the data type of the
contents of the cell. Could the .Type property be used? Any method for
solving this would be appreciated.