yes the syntax varies depending on where the other macro is located
if it's in the same workbook you can just type the name of the macro with
module name in front of it if you need it
sub sfsf()
'yourcode here
'end now call other macro
NEWMACRO
end sub
or
sub sfsf()
'yourcode here
'end now call other macro
module1.NEWMACRO
end sub
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.