Application.Run for every open workbooks (one by one)
Hi Dave,
Hi John,
Thanks a lot for your answers!
Just for feedback:
The code provided by Dave was almost perfect, I just needed to add
"wbk.Activate", as below:
-------------
For Each wbk In Application.Workbooks
wbk.Activate
Application.Run "'" & wbk.Name & "'!SameMacro"
Next i
------------
On the other hand, I was unable to run your code, John. Suppose I'm
missing something...
Cheers,
Mark
|