Find method of Range object

In this article, we will use find method of Range object to highlight the cell which contains the value similar to search words. Raw data for...

Explanatory Formulas

Requirements: - Basic knowledge of vba - Use of tables/named ranges When working with workbooks on and off, sometimes months between revisits t...

An Improved Custom Random Numbers Function

In this article, we will create a custom function to generate random decimal numbers between the defined ranges. Raw data for this example consists o...

Function for returning the user name using VBA in Microsoft Excel

The function below will return the user name for the logged on user, works in both Windows NT and Windows95/98. Public Declare Function GetUserName L...

Macro to return user name and computer name in Microsoft Excel

In this article, we will create a macro which will return computer and user name for the logged in user. In this example, we want to extract computer...

Problem: The Characters Are in Reverse Order

To reverse the character order, create and add a Custom Function to the Insert Function dialog box: 1. Press Alt+F11 to open the VBE. 2. In VBAPro...

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