View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Luke Alcatel Luke Alcatel is offline
external usenet poster
 
Posts: 7
Default Identify cells based on format

Depends on what you mean by number. You can test the contents with
IsNumeric which will have a true result for any kind of number such as -1.7.
If you want to limit the test to something more specific such as integers,
look at the "like" function.

HM

"Alejandro" wrote in message
...
Hello there,

In several occassions I've tried unsuccessfully to identify specific cells
based on their contents. In this particular case I'm trying to identify
(and
delete) the cells of a column that contain numbers instead of text. I
tried
using the format property but I didn't get too far. Can anyone help?

Thanks!

AP.