Filename formula

There may be times when you need to insert the name of the current workbook or worksheet in to a cell.


The problem with this is that it gives the complete path including drive letter and folders.

Pick the Excel Path.


Pick the Workbook name.


Pick the Worksheet name.


Popular posts from this blog

50 Excel VBA Oral Interview Questions