Re: How to loop
- From: "saman110 via OfficeKB.com" <u35670@uwe>
- Date: Tue, 24 Jul 2007 19:46:45 GMT
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) |
|