removing a row if it is non numeric
 

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

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

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

removing a row if it is non numeric
 

Andy,

Try the following:

ActiveSheet.Columns("K").SpecialCells(xlCellTypeCo nstants,
xlTextValues).Delete


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


"andycharger" wrote in
message ...

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


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/

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