Posted to microsoft.public.excel.programming

PJFry

external usenet poster

Posts: 143

Do Until Loop Not Working

Sub HideRow()

Range("B15").Select

Do Until ActiveCell = "STOP"
If ActiveCell.Value = 0 Then
ActiveCell.EntireRow.Hidden = True
ActiveCell.Offset(1, 0).Select
Else
ActiveCell.Offset(1, 0).Select
Loop

End Sub

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	Paul Black	Excel Programming	7	August 29th 07 08:33 PM
Why is this loop not working?	Mike R.	Excel Programming	12	July 25th 07 02:26 PM
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

All times are GMT +1. The time now is 12:05 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us