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.
|