Testing for text
 

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

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