Re: How to loop

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: 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)
  • Re: First time in VBA for Word, how to loop through document
    ... ' Macro created 16-08-98 by Doug Robbins to save each page of a document ... I am new to VBA for Word, but I've programmed extensively with VBA for ... Macro with a nested loop that will loop through each section, ... The first line in each section is assigned an Outline level of 1, ...
    (microsoft.public.word.vba.beginners)