Microsoft KB Archive/51951

Excel: Macro Incorrect on Page 113 of Functions and Macros Last reviewed: November 1, 1994 Article ID: Q51951

SUMMARY The formula in cell A5 of the macro listed on page 113 of the "Microsoft Excel: Functions and Macros" manual does not perform the desired logical function. The correct formula should be as follows: =IF(A4>1,GOTO(A13),IF(AND(A2>1,A3>1),GOTO(A13))) The original formula will cause a #REF! error when a discontinuous area is active at the time the macro is run.

KBCategory: kbother KBSubcategory: Additional reference words: noupd Last reviewed: November 1, 1994 © 1998 Microsoft Corporation. All rights reserved. Terms of Use.