|
Hi Everybody,
I would like to use the variables in the activeworkbook from a macro placed in the personal.xlsb. I can run the macro "counter" with the command:
Application.Run "personal.xlsb!counter"
but after the check the values in the immediate window have no values.
I tried so too:
Application.Run "personal.xlsb!counter", fr, lr, fc, lc
but at the end no values for fr,lr,,fc,lc
In the personal.xlsb have the sub:
Public Sub counter(fr, fc, lr, lc)
.....
and the variables as Public declared.
Thanks for your help.
|