Posted to microsoft.public.excel.programming

external usenet poster

Posts: 271

Search and delete row

I have a table of data. I need a code that will search the column range
B3:B? (I don't know where the data will end). If there is a value in range
B3:B? that equals the value in B2, then I need that entire row deleted and
the rest of the data shifted up. Also, there may not be a value in B3:B?
equal to the value in B2. In that case, I need nothing to happen. Thank in
advance.

--
Thanks
Shawn

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
keyword search and delete row	mikeyVo	Excel Discussion (Misc queries)	2	August 1st 06 05:32 PM
Search and Delete	Ben H	Excel Programming	2	July 18th 06 08:29 PM
SEARCH AND DELETE	Sean[_15_]	Excel Programming	12	May 24th 06 04:21 PM
Add-in to search and delete	Robert Christie[_3_]	Excel Programming	1	October 21st 04 05:49 PM
Search and Delete	scottnshelly[_56_]	Excel Programming	0	July 4th 04 03:33 AM

All times are GMT +1. The time now is 11:50 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us