Microsoft KB Archive/51951

{| = Excel: Macro Incorrect on Page 113 of Functions and Macros =
 * width="100%"|

Last reviewed: November 1, 1994

Article ID: Q51951

SUMMARY
The formula in cell A5 of the macro listed on page 113 of the &quot;Microsoft Excel: Functions and Macros&quot; 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.
 * }