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

**mehmetcik** · 01-15-2019, 08:14 AM

Ahh You are using the Personal Macro as a subroutine.

Public LR As Integer

Sub test()

get_boards(LR)

End Sub

Or

Sub test()

Call get_boards(LR)

End Sub

and the Code from personal.xlsb

Public Sub get_boards() 

LR=Cells(Rows.Count, 1).End(xlUp).Row

End Sub

**sandordan_01** · 01-15-2019, 08:31 AM

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

Application.Run "'C:\Users\Q36804\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.xlsb'!get_boards"

or with a Parameter

Application.Run "'C:\Users\Q36804\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.xlsb'!get_boards", lr

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

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