passing arguments by postion through application.run
ApplicationRun "workbook1.xls!module1.macro",noh,nohl
where noh and noh1 ae the variables holding the values passed.
--
Regards,
Tom Ogilvy
"ben" wrote in message
...
I am trying to call a macro from a seperate workbook than the one that
called
it, but the sub calling the other sub needs to pass named arguments
(noh(),nohl()) but the application.run method does not allow the passing
of
named arguments, it says it they need to be passed by postion. I'm not
quite
sure what that means, how do I cause that other macro to be open
"workbook1!module1.macro",noh,nohl while passing those arguments
(variables)
either with application.run or another syntax?
|