The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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

Microsoft KB Archive/51951

Excel: Macro Incorrect on Page 113 of Functions and Macros

SUMMARY