Posted to microsoft.public.excel.programming

Mike R.

external usenet poster

Posts: 59

Why is this loop not working?

Hi -
this seems like a pretty easy loop statement. What am I doing wrong? I am
trying to see if a value in a row equal's the word START and if so, delete
that row.
Help..

irows = ActiveSheet.UsedRange.Rows.Count
For iloop = 2 To irows
If Cells(iloop, "D").Value = "START" Then Cells(iloop,
"D").EntireRow.Delete
Next iloop

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
Loop not working!!	Simon	Excel Programming	2	August 2nd 05 04:16 PM
Do...Loop not working	Sunny Lin	Excel Programming	1	April 14th 05 01:19 AM
for next loop not working	Tom Ogilvy	Excel Programming	0	September 27th 04 05:36 PM
for next loop not working	Ron Rosenfeld	Excel Programming	0	September 25th 04 04:07 AM
Find value loop not working	Christiane[_6_]	Excel Programming	3	April 6th 04 01:53 AM

All times are GMT +1. The time now is 10:18 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us