Re: How to loop

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Unfortunatly I cant get it right.

I want to run this macro 6 or 7 times, or loop back to second row and delete
those word until there is none.

thx.

Don Guillett wrote:
think about it.
cells(row,column)

I have Columns A:G and many cells I want to delete entire Rows if the
content
[quoted text clipped - 20 lines]
Next i
End Sub

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200707/1

.

Relevant Pages

  • Re: PC Word Macro Not Working in Mac Word
    ... I wrote my original in Mac Word, ... .Execute Replace:=wdReplaceAll ... Do ' A post-test loop! ... I did a test macro with basically just the code you ...
    (microsoft.public.mac.office.word)
  • RE: Loop Training: Password Finder
    ... 'The cycles on your g loop would be phenominal in your case. ... Dim Solution As String ... I have a macro below, ... > Exit Sub ...
    (microsoft.public.excel.programming)
  • RE: Word 2003 crashes with 2003 vba macro
    ... I found out that the loop in this case never ... One of the ways in which a macro can cause Word to hang is by having a loop, ... As the cycles of the loop proceed, pos1 increases until the cursor is ... Dim i As Integer, pos As Single, pos1 As Integer ...
    (microsoft.public.word.vba.general)
  • Re: User initiated break/actions during macro execution
    ... > an infinite loop until the user presses a stop button. ... > speed of the macro as it runs (the idea being, ... > to allow users initiated actions DURING macro execution. ...
    (microsoft.public.excel.programming)
  • Re: nested grinding..
    ... Next" in the following macro: ... Dim data As Range, stab As Table, ttab As Table ... Set scat = stab.Cell.Range ... For a Do While ..Loop, it would be structured as follows (this is not an ...
    (microsoft.public.word.vba.beginners)