Solved get name of worksheets

December 8, 2015 at 16:55:21
Specs: Windows 7
how to get the names of worksheets in a workbook of Excel? By formula or VBA is ok. I prefer to formula

See More: get name of worksheets

Report •

December 8, 2015 at 17:15:37
✔ Best Answer
To get the Complete File name, path & all, use =CELL("filename",A1)
to get just the sheet name then something like:


should work.


message edited by mmcconaghy

Report •

December 9, 2015 at 12:36:00
Just remember that the file must be saved before those formula will work. The "filename" must exist in order for the info to be extracted.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

Ask Question