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