Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
passing arguments by postion through application.run
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing Arguments in Excell | Excel Worksheet Functions | |||
Passing Variable Number of Arguments to a Sub | Excel Discussion (Misc queries) | |||
passing reference arguments to VBA function | Excel Programming | |||
Passing Arguments | Excel Programming | |||
Passing arguments to a sub routine... | Excel Programming |