View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Edgar Thoemmes[_4_] Edgar Thoemmes[_4_] is offline
external usenet poster
 
Posts: 16
Default 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