Change Text to Number Using VBA

In a recent task, I was doing filter through VBA on a number column. But that number column had numbers in text format. When I run the VBA script, it ...

3 Best Ways to Find Last non-blank Row and Column Using VBA

Finding last used row and column is one of the basic and important task for any automation in excel using VBA. For compiling sheets, workbooks and arr...

Consolidate/Merge multiple worksheets into one master sheet using VBA

Sometimes we want to merge multiple sheets into one sheet so that we can easily analyse the data and turn it into some useful information. This articl...

What is the difference Between ByRef and ByVal Arguments? | VBA Interview Question

This is one of most asked questions in VBA interviews. In this article we will learn what’s the difference between ByVal and ByRef arguments in exce...

How to Delete Empty Columns through VBA in Microsoft Excel?

In this article, we will learn about how to delete empty columns through VBA in Microsoft Excel. We will delete the columns which are completely empty...

How to Create User Defined Function through VBA

In this article, we are going to learn how to make user defined function to extract the text only from the string through VBA. User Defined Function:...

How to Insert the Row after Every 5th Row through VBA

In this article, we will learn how to insert the row after every 5th row through VBA in Microsoft Excel. Let’s take an example and understand: W...

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