Posted to microsoft.public.excel.programming

external usenet poster

Posts: 42

To delete the rows if certain cells contain the following

Hi,

Eg.. If column A:A contains numbers like VA11111111, VA22222222, VA33333333
and VA00000000, I would like to write a simple macro that can delete the rows
if cell column A:A contain the numbers..

Can anyone help.?

ddiicc

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
Allow Delete cells but not rows	Elton Law[_2_]	Excel Worksheet Functions	1	April 30th 09 10:53 AM
delete rows with empty cells	Slohcin	Excel Discussion (Misc queries)	14	December 19th 06 05:14 PM
Delete rows where cells contain various criteria	gmunro	Excel Programming	1	March 10th 05 02:27 PM
Delete Rows where all cells = 0	William[_2_]	Excel Programming	0	August 11th 04 04:34 PM
Delete Rows where all cells = 0	Ron de Bruin	Excel Programming	0	August 11th 04 04:23 PM

All times are GMT +1. The time now is 02:34 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us