Excel: Creating a Loop in a Macro in Versions 1.06 and Earlier

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("C",1)          initialize counter
   =IF(C<=#,GOTO(ref),)      check counter against end condition
   =SET.NAME("C",C+1)        increment counter

The following example loops three times:

   =SET.NAME("Counter",1)
   =IF(Counter>3,RETURN())         /* This step is in cell A2 */
   =SET.NAME("Counter",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 "Microsoft Excel Functions and Macros" version 2.2 manual. For Excel 1.50, see pages 229 and 274 in the "Microsoft Excel Arrays, Functions, and Macros" manual.

KBCategory: kbother
KBSubcategory:
Additional reference words: 1.00 1.03 1.04 1.06 1.50 2.20

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: October 31, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.