View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ben Ben is offline
external usenet poster
 
Posts: 509
Default 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?