how to stop this loop....

**fonzie29** · 12-03-2013, 02:35 AM

Thanks Ciao Holger!

Vimalanathk,
Try out this code.

Sub test()
Dim row As Long
row = 2
Do
    If Cells(row, 1).Value <> "x" And Cells(row, 1).Value <> "" Then
        Cells(row, 12).Value = "=+RC[-11]"
    End If
    row = row + 1
Loop Until Cells(row, 3).Value = "Powered by GL Compliance Manager"
End Sub

Thanks,
Fonzie

**vimalanathk** · 12-03-2013, 03:21 AM

Your bottom code is giving me the output for blank line of status columns also where i need the out put only the status is updated... it should be blank for status blank line items.

Regards,
Vimala K

**vimalanathk** · 12-03-2013, 03:45 AM

Hi Fonzie,

I just changed your script with my requirement and I am getting the output.

Thanks a lot for your help.

Regards,
Vimala K

how to stop this loop....

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: how to stop this loop....

Re: how to stop this loop....

Re: how to stop this loop....

Thread Information

Users Browsing this Thread

Similar Threads

Loop Does Not Stop

Can't get my loop to stop!!

Loop until won't stop!?

Hot key to stop a LOOP

Stop a loop

Bookmarks

Bookmarks

Posting Permissions