Export (0) Print
Expand All

Range.Run Method

Office 2007
Runs the Microsoft Excel macro at this location. The range must be on a macro sheet.

Syntax

expression.Run(Arg1, Arg2, Arg3, Arg4, Arg5, Arg6, Arg7, Arg8, Arg9, Arg10, Arg11, Arg12, Arg13, Arg14, Arg15, Arg16, Arg17, Arg18, Arg19, Arg20, Arg21, Arg22, Arg23, Arg24, Arg25, Arg26, Arg27, Arg28, Arg29, Arg30)

expression   A variable that represents a Range object.

Parameters

NameRequired/OptionalData TypeDescription
Arg30OptionalVariantThe arguments that should be passed to the function.

Return Value
Variant

Remarks

You cannot use named arguments with this method. Arguments must be passed by position.

The Run method returns whatever the called macro returns. Objects passed as arguments to the macro are converted to values (by applying the Value property to the object). This means that you cannot pass objects to macros by using the Run method.




Community Additions

ADD
Show:
© 2014 Microsoft