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:
and the Code from personal.xlsb![]()
Sub test() Dim lr As Integer Application.Run "'C:\Users\Q36804\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.xlsb'!get_boards", lr End Sub
Thanks for your support!![]()
Public lr as integer Public Sub get_boards(ByRef lr As Integer) lr=Cells(Rows.Count, 1).End(xlUp).Row End Sub
Bookmarks