to use variables from macro of personal.xlsb

Originally Posted by Stormin'

OK, I've checked and ByRef doesn't work. You have a few options as far as I can see:

It will work as long as you use a late bound variable to hold the Application instance (i.e. a Variant or Object type). So this will work

    Dim fr, fc, lr, lc
    Dim app
    Set app = Application
    app.Run "Personal.xlsb!counter", fr, fc, lr, lc

whereas this will not

    Dim fr, fc, lr, lc

    Application.Run "Personal.xlsb!counter", fr, fc, lr, lc