How To Find The Last Row in Microsoft Excel 2010

In this article, you will learn how to find the last row using VBA. Let us understand with an example: Following is a snapshot of Sales Report w...

How To Find Cell Address Of The Maximum Value In A Column In Microsoft Excel

In this article, you will learn how to find address of the cell containing maximum value in a column. We can use MAX, MATCH & ADDRESS functions...

How To Filter The Data Based On The Selection Of Cell Using VBA In Microsoft Excel

In this article, you will learn how to filter the data based on the selection of cell.   You need to follow the below steps:   ...

How to Extract Nth Word from Text String Using VBA in Microsoft Excel

In this article, you will learn how to extract the nth word from text string. We will use VBA code to create UDF to find the nth word in a string. ...

How To Extract All Text Strings After A Specific Text String In Microsoft Excel

In this article, you will learn how to extract all text strings after a specific text. If there is a requirement to retrieve the data from a column...

How to Do Two Way Lookup In Microsoft Excel

In this article, you will learn how to do two way lookup. We will use a combination of INDEX & MATCH functions. Let us understand with an ex...

How to Delete Drop Down List in Microsoft Excel

In this article, you will learn how to delete drop down list. You can delete the drop down list from either cell(s) or all the cells that contain the...

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