Delete all blank worksheet using Personal Macro
In this article, we have create the a Personal Macro to delete all blank worksheet from active workbook. You can use this for the workbook wherein you have multiple worksheet
Tag: Personal Macro
Create Auto Table of Contents in Excel Workbook
In this article, you will learn how to create a Table of Contents for any active workbook using VBA. We have created VBA code which you can put in your
Create Multiple Names using VBA in Excel
Our daily Excel activities can be automated using VBA. Here we have created an example of creating the Name range in Excel using VBA. Lets’ say we have below given
VBA: Quickly merge cells with same value in Excel
In this article you will learn how to quickly merge same cells in Excel using VBA. Using this VBA code, you can merge multiple columns data together. This trick can
Quick Data Formatting by Personal Macro
In this article you will learn how to create a Personal Macro in MS Excel. I have created this personal macro to format the data quickly.Any macros that is stored