Sets or returns the value of the macro. Any type of value, including numbers, strings, and objects, can be stored in macro values (objects should only be stored in temporary macros since they will not be persisted between sessions). Macros can reference other macros but cannot reference themselves.
Macro.Value As Variant
Applies to Macro object