Convert Small Letters into Uppercase for Some Columns

How to Convert Small Letters into Uppercase Letters for few columns using VBA in Microsoft Excel   In this article we will learn how to con...

Get Sheet Names

How To Get Sheet Names Using VBA in Microsoft Excel   In case you want to find out a way which can get you all the names of the sheet that ...

VBA To Open Latest File in Folder

How to Open Newest File in a Folder in Microsoft Excel   In case you want a VBA code which will allow you to open the recently saved file i...

How to Speed Up Macros in Pivots

How to improve the speed of VBA macro code? In this article, we will learn how to run macros faster with pivots, using VBA code. Question): I am...

UDF - Extracting Email Address from Text

In case you want a process to help you in retrieving the email address from the string then this article is for you. In this article, we will create U...

Update Sheets through VBA

In this article, we are going to learn how to update the data from one sheet to another sheet through VBA in Microsoft Excel. Let’s take an examp...

How we can format date through VBA?

In this article we will learn how to format the date through VBA. Let’s take an example to understand how and where we can format the cell in sho...

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube