All over the INTERNET I found that
CELL function returns the full file path, the Drive letter, Workbook and Sheet name in a format of
C:\Folder\[workbook.xlsm] sheetname more or less by entering the following formula into a cell,
Doesn't work...at least not for me.
I do not get
path [workbook.xlsm] Sheet name, which is the format every site states should be the result, and instead I get,
No brackets, No sheet name.
Can any one suggest me how to fix this issue!