Posted to microsoft.public.excel.programming

AlanW

external usenet poster

Posts: 29

Do Loop

Could anyone please tell why the funnel is kept running without stopping even
after the expected task is completed.

Sub Macro()
Do Until blanks
For Each cell In Range("A1:A10")
Select Case cell.Value
Case "W"
cell.Offset(0, 1).Interior.ColorIndex = 1
Case "Q"
cell.Offset(0, 1).Interior.ColorIndex = 7
Case Else
cell.Offset(0, 1).Interior.ColorIndex = 9
End Select
Next
Loop
End Sub

Thank you

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
Naming Worksheets - Loop within a loop issue	klysell	Excel Programming	5	March 29th 07 05:48 AM
Naming Worksheets - Loop within a loop issue	klysell	Excel Programming	0	March 27th 07 11:17 PM
(Complex) Loop within loop to create worksheets	klysell	Excel Programming	1	March 20th 07 12:03 AM
Advancing outer Loop Based on criteria of inner loop	ExcelMonkey	Excel Programming	1	August 15th 05 05:23 PM
Problem adding charts using Do-Loop Until loop	Chris Bromley[_2_]	Excel Programming	2	May 23rd 05 01:31 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us