Apart from the way arguments are set out, and whether or not a return value
is required, is there any other difference between "Call" and "Run" please?
Regards, Brett

The best place is to refer is VBA help.

RUN is a 'Method' which allows values to be passed but not named variables
or objects. The objects will be converted to its value. RUN method returns
whatever the macro returns.

Meanwhile CALL is a 'statement' ; if used will transfer the control to the
procedure/function. Even without using CALL you can still call the procedure
but if you use the Call keyword then that requires arguments to be passed
enclosed in parentheses.

CALL MyProc(arg1,arg2)
OR
MyProc arg1,arg2

If this post helps click Yes
---------------
Jacob Skaria


"Brett" wrote:

> Apart from the way arguments are set out, and whether or not a return value
> is required, is there any other difference between "Call" and "Run" please?
> Regards, Brett

Thanks Jeff

"jeffrey.ccs" wrote:

>
> Hi
>
> The main difference for me from a practical standpoint is that 'Call'
> does not permit the use of variables in a macro name and 'Run' does. Not
> applicable much but useful to know if you need it.
>
> Regards
>
> Jeff
>
>
> --
> jeffrey.ccs
> ------------------------------------------------------------------------
> jeffrey.ccs's Profile: http://www.thecodecage.com/forumz/member.php?userid=313
> View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=105129
>
>

Thanks again Jacob.

"Jacob Skaria" wrote:

> The best place is to refer is VBA help.
>
> RUN is a 'Method' which allows values to be passed but not named variables
> or objects. The objects will be converted to its value. RUN method returns
> whatever the macro returns.
>
> Meanwhile CALL is a 'statement' ; if used will transfer the control to the
> procedure/function. Even without using CALL you can still call the procedure
> but if you use the Call keyword then that requires arguments to be passed
> enclosed in parentheses.
>
> CALL MyProc(arg1,arg2)
> OR
> MyProc arg1,arg2
>
> If this post helps click Yes
> ---------------
> Jacob Skaria
>
>
> "Brett" wrote:
>
> > Apart from the way arguments are set out, and whether or not a return value
> > is required, is there any other difference between "Call" and "Run" please?
> > Regards, Brett