Posted to microsoft.public.excel.programming

Gareth[_3_] Gareth[_3_] is offline

external usenet poster

Posts: 109

check range for certain value

I want to check a range (P:T) in every row. These cells will contain 2
letter codes, if the code 'MS' is found ON ITS OWN then I want to delete
that row. The number of rows on the sheet will vary.

Examples:

MS TG do not delete
MS delete
no codes at all do not delete
BB DD FG TR do not delete

Thanks in advance.

Gareth

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
Check for empty range in vba	Phil	Excel Discussion (Misc queries)	1	April 28th 06 09:57 PM
Q: check a range values	JIM.H.	Excel Discussion (Misc queries)	2	October 21st 05 12:26 AM
can a formula check for a certain value in a range?	Lee IT	Excel Discussion (Misc queries)	1	April 7th 05 04:31 PM
How to check cells in a range for a value	BCS	Excel Programming	1	October 3rd 03 09:20 PM
check if range containing values	Markus Serbel	Excel Programming	2	July 14th 03 11:26 AM

All times are GMT +1. The time now is 11:51 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us