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.