removing a row if it is non numeric

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
 
C

Chip Pearson

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
Click to expand...
to creating financial statements
 
Top