removing a row if it is non numeric

  • Thread starter Thread starter andycharger
  • Start date Start date
A

andycharger

Thanks for the help on blank cells. but I have tried it and I also nee
to get rid of rows that have text in column K.

How can I delete rows that have Text in Column K using the macros an
VB?

Basically, I just want to keep rows that have NUMERIC cells in colum
K.


Any help would be appreciated.

Thanks

And
 
Andy,

Try the following:

ActiveSheet.Columns("K").SpecialCells(xlCellTypeConstants,
xlTextValues).Delete


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


andycharger said:
Thanks for the help on blank cells. but I have tried it and I also need
to get rid of rows that have text in column K.

How can I delete rows that have Text in Column K using the macros and
VB?

Basically, I just want to keep rows that have NUMERIC cells in column
K.


Any help would be appreciated.

Thanks

Andy


------------------------------------------------

~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide
Click to expand...
to creating financial statements
 
Back
Top