How to Combine Multiple Columns into Single Column Using VBA in Microsoft Excel

In case you have a requirement on combining multiple columns to on column & you did not have a clue then this whole article is for you. In this ar...

Data Validation Width is too Small in Microsoft Excel 2010

In this article, you will learn how to increase the size of the selected cell that contains data validation. If you are working on a report that co...

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...

How to Launch Word File Using VBA in Microsoft Excel

The number of people using Word & Excel are quite high, however, they are not well versed when it comes to opening word file from Excel workbook. ...

How to Loop Through Each Worksheet & Write Text in Same Cells in Microsoft Excel

If you want a quick way to write same text in same cell position then this article is for you. In this article, we will learn how to loop through in a...

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 ...

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...

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.