Count Worksheets In Multiple Files

Consider a situation, where you are encountering with number of excel files on a daily basis & you want a quick mechanism to help you finding the ...

Hide Inactive Workbooks Through VBA

If you are working on multiple workbooks at the same time, and you need a macro to help you in hiding all the inactive workbooks, then this article wi...

Combine Multiple Worksheets into One

In this article, we are going to learn how to assemble the data from different workbooks through VBA in Microsoft Excel. Let’s understand with a ...

Open and Close Excel Workbook using VBA

In this article we will learn about to close and open method in Excel VBA that is used for opening the close workbook and also close the open workbook...

VBA to Prevent From Changing Worksheet Name in Microsoft Excel

Sometimes our VBA code or some formulas depend on the Worksheet name. If the name of the worksheet changes the the behavior of the VBA code or formula...

How To Dynamically Hide Or Unhide Multiple Tabs Using VBA in Excel

Consider a situation in which you need to hide & unhide multiple sheets at a time. If someone is hiding & unhiding manually then this will tak...

Determine if a sheet exists in a workbook using VBA in Microsoft Excel

There could be a time when you have to check if a worksheet, which you have create or deleted in a workbook in a VBA macro / code, exists. We can do t...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.