Testing for text
Edgar,
Use the IsNumber Function to test the cell value.
--
HTH
RP
"Edgar Thoemmes" wrote in message
...
I sort my data which is a combination of numbers and text, via a macro so
that the numbers are first. What I would like to do is delete out all
cells
which contain text.
What I cant figure out how to test for the first row without a number in
column A so I can delete out all rows after that one.
Can anyone help?
Thanks
|