Microsoft KB Archive/28756

{| = Excel: Creating a Loop in a Macro in Versions 1.06 and Earlier =
 * width="100%"|

Last reviewed: October 31, 1994

Article ID: Q28756

SUMMARY
By setting up a simple counter routine, counter loops control the number of times a macro loops. Each routine needs the following three parts:

=SET.NAME(&quot;C&quot;,1)         initialize counter =IF(C<=#,GOTO(ref),)     check counter against end condition =SET.NAME(&quot;C&quot;,C+1)       increment counter The following example loops three times: =SET.NAME(&quot;Counter&quot;,1) =IF(Counter>3,RETURN)        /* This step is in cell A2 */ =SET.NAME(&quot;Counter&quot;,Counter+1) =GOTO(A2)

MORE INFORMATION
Microsoft Excel versions 1.50 and 2.20 offer FOR and WHILE loops to control how many times a macro loops. For more information regarding these commands, see pages 220 and 290 in the &quot;Microsoft Excel Functions and Macros&quot; version 2.2 manual. For Excel 1.50, see pages 229 and 274 in the &quot;Microsoft Excel Arrays, Functions, and Macros&quot; manual.
 * }