Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing Non-Numeric Characters - Automatically - How? | Excel Discussion (Misc queries) | |||
Numeric in Text to convert back to the form of Numeric for VLookup Purposes | Excel Discussion (Misc queries) | |||
Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
removing leading zeros in numeric fields | Excel Discussion (Misc queries) | |||
Removing Non-Numeric Characters | Excel Discussion (Misc queries) |