Trying to run macro from another book which is open but not active such as:
Run ("'workbookone.xlsm'!SORTF")
Except I need to do it like this by referencing part of the name of the workbook from a range:
Run ("'workbook" & range("A1") & ".xlsm"' !SORTF")
The "one" part of the name would come from range("A1").
Not sure if this possible or I don't have the quotes done correctly but it doesn't work.
Bookmarks