is a sub able to accept more than 1 veraibale fed into it?

[luv2glyd]

I have a sub that I want to run with several variables passed into it. Is that possible? So if I call my_macro(var_1) within a macro, it works fine, but my_macro(var_1, var_2, var_3) does not.

More than one variable works if I set up my_macro as a function, but then to call it within another sub so it works, I have to set up a useless variable and then write useless_var = my_macro(var_1, var_2, var_3) - something I'd like to avoid.

Thanks

[MrShorty]

This (https://msdn.microsoft.com/en-us/lib.../gg278504.aspx ) strongly suggests that it should be able to accept more than one argument. The example given at the end even shows 2 arguments to the sample sub.

Can you post a sample of your code where multiple arguments is not working? Can you explain in more detail what "does not work" means (syntax error, error number, wrong answer)?

[Norie]

You should be able to pass multiple arguments to a sub with no problem.

How are you calling the sub?

[luv2glyd]

Here's a short example:

Please Login or Register  to view this content.

When I run mysub_1, "mysub_2(1,2)" line turns red and then an error box pops up saying "Compile Error: Expected: ="

[Norie]

Remove the (), or use Call.

Please Login or Register  to view this content.

[luv2glyd]

Aha! Ok, thank you. I've always done it the way I showed above (though with no more than one variable fed into it). Any idea why I did not have to use "Call", or drop the () ?

Thanks

[romperstomper]

You were lucky and obviously never trying to pass an object variable. Using the parentheses dereferences or evaluates the argument passed.

[Doc.AElstein]

Aha! Ok, thank you. I've always done it the way I showed above (though with no more than one variable fed into it). Any idea why I did not have to use "Call", or drop the () ?...

What Mr rorya said is also explained well by Mr shg here
http://www.excelforum.com/excel-prog...ml#post4226271
Jacky

Note I bet in your original

my_macro(var_1)

suggestion, than actually when you pasted that in the VB Editor Window, then it would have changed it to include a space

my_macro (var_1)

which is consistant with the syntax variations suggested to you

Please Login or Register  to view this content.

And just to reiterate...

doing this

my_macro (var_1)

or this

Call my_macro((var_1))

makes this

Please Login or Register  to view this content.

work as if you had this

Please Login or Register  to view this content.

or alternatively makes this

Please Login or Register  to view this content.

work as if you sent a number rather than Var_1 at the calling line