execute macro from personal.xlsb and get the value of the variable

Hi All,

I would like to call a macro from the personal.xlsb and receive the value (lr) from it, but I receive no value for the variable lr

the Code that start the macro in personal.xlsb:

Please Login or Register  to view this content.

and the Code from personal.xlsb

Please Login or Register  to view this content.

Thanks for your support!

Thank you but I Need the last Number back to my macro I think:

run macro --> call an another macro from personal.xlsb and take the number of the last row --> go back to the start macro and use the number of last row for the next steps

Thank you it works if you are in the same workbook to start from a separate wb not I can run the macro with

Please Login or Register  to view this content.

or with a Parameter

Please Login or Register  to view this content.

but I dont receive back the number of the last row, it is blank