Microsoft KB Archive/48482

From BetaArchive Wiki


Excel: Using More Than One Macro Function in a Single Cell

Last reviewed: November 2, 1994
Article ID: Q48482

SUMMARY

To combine macro commands in Microsoft Excel, type a plus sign (+) between the macro commands. This makes it possible to execute more than one command per line.

For example, the following command selects cell A1 and copies it:

   =SELECT(!A1)+COPY()

Note: The GOTO() command should not be combined with any other command because the GOTO() command branches the macro and does not activate any commands that are combined with it.


KBCategory: kbother

KBSubcategory:

Additional reference words: 1.04 1.06 1.50 2.20 3.00


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