Posted to microsoft.public.excel.programming

external usenet poster

Posts: 46

Coding

Thank you,

EJE

On Sun, 13 Aug 2006 19:29:11 -0600, "Dave Patrick"
wrote:

Here's one way;

For r = 100 To 1 Step -1
If LCase(Trim(Cells(r, 1).Text)) = "abc" Then
Cells(r & "," & r).EntireRow.Delete
End If
Next

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
How to fix the coding?	Eric	Excel Worksheet Functions	0	February 26th 08 03:38 AM
Coding	metaltecks	Excel Discussion (Misc queries)	1	April 17th 06 10:12 PM
"=ROW()-1" type of coding doesn't appear in a filter / is there coding that does?	StargateFan[_3_]	Excel Programming	10	October 6th 05 01:18 PM
Implant macro coding into ASP coding	Sam yong	Excel Programming	5	September 15th 05 10:37 AM
Coding help	fpd833	Excel Programming	2	November 12th 04 08:22 PM

All times are GMT +1. The time now is 12:03 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us