sheet name

Few very useful and small macros

Dear LEM Readers,   In this first part of this article I am going to share very small but useful vba codes which are most frequently used in day-to-day vba programming. Many of my readers had requested for them so I have clubbed all of them together and made one article :) Enjoy reading them...   Closing All Open Workbooks [...]

File Name Formula

There are few instances when we want to store the File Name or Current Workbook Name in a particular Cell. This is very easy. This can be done by using Cell() function as shown below: Syntax: =CELL("filename") Returned Value: C:\Users\Vish\Desktop\[Test.xlsx]Sheet1 Note: The problem with this is that it gives the complete path including Drive and folders with Sheet Name. To [...]