Remove Trailing Space through VBA

In case you want a VBA code to remove all the trailing spaces in only active sheet then this article will definitely help you. Many times we left a sp...

Data Consolidation through Excel VBA

In this article, we are going to learn VBA how to write the macro to consolidate the data in Microsoft Excel. Consolidate Data: -This option is used ...

How to update data from one sheet to Another Sheet through VBA in Microsoft Excel

Sometimes we want to use one sheet of the excel as a form that is used to get the inputs from the user. the data entered by the user, we try to save i...

Extract Specific Color Index using VBA

In case you want to copy a particular formatted cell or colored cells from one column to the next column then this article is for you. In this article...

How to use comment option through VBA

In this article, we are going to learn how to use comment option in Microsoft Excel through VBA. Comment is the source by which we can convey the m...

Delete all Comments in Microsoft Excel

In Excel, while preparing reports for boss/management, we tend to insert comments in order to let the other person inform the status of the task. Comm...

VBA Message Box to Update Today's Day in Microsoft Excel 

If you want to be automatically update today’s day of the week then this article is for you. This article focus on updating user the current day of ...

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.