Testing for text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text To Columns then insert rows 9
Excel VBA help: Text file formatting 19
Column number of last column that returns value ignore formulas 8
Find and move cells with text 8
Find Specific Rows in Range and Create New Tab 18
Macro for fast deletion of rows that conatin certain data. 2
Time issues in code 6
Delete rows based on contents of Col A 0

Back
Top