removing a row if it is non numeric

Posted to microsoft.public.excel.programming

andycharger[_2_] andycharger[_2_] is offline

external usenet poster

Posts: 1

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Removing Non-Numeric Characters - Automatically - How?	emerald	Excel Discussion (Misc queries)	6	April 4th 06 08:03 PM
Numeric in Text to convert back to the form of Numeric for VLookup Purposes	achilles	Excel Discussion (Misc queries)	4	February 6th 06 07:05 AM
Match Single Numeric Criteria and Return Multiple Numeric Labels	Sam via OfficeKB.com	Excel Worksheet Functions	0	December 29th 05 08:44 PM
removing leading zeros in numeric fields	dingy101	Excel Discussion (Misc queries)	3	November 21st 05 03:46 AM
Removing Non-Numeric Characters	GlenS	Excel Discussion (Misc queries)	5	October 12th 05 10:50 AM

All times are GMT +1. The time now is 08:23 AM.

Menu

About Us