In this article, we will create a custom function to calculate the sum of digits in a cell. Sample data for this example consists of sales data. ...
In VBA code, if you have to refer to certain worksheet functions like Sum, Vlookup, etc, you can use them directly by using the Application object. ...
In this article, we will see how to use a User Defined Function (UDF) defined in another workbook. For this example, we have created a UDF “Reverse...
In this article, we will create a custom function to generate a list of unique and random numbers between the specified ranges. In this example, we c...
Return error values from user defined functions With the example function below you can get user defined functions to return error values just like ...
In this article, we will create a macro to extract unique values from the defined range. Raw data for this example consists of duplicate entries of c...
In case you are wondering how someone can find every nth item in a column. In this article we will learn how to return every n-th item from a list. We...
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.
