This tutorial explains how to use Excel VBA Custom Function to check if worksheet exists, and add new worksheet if worksheet doesn't exist
Excel VBA Custom Function check if worksheet exists
Sometimes we want to manipulate worksheet in a workbook but we are not sure if the worksheet exists. For example, we want to add a worksheet, if it already exists, skip the adding worksheet code.
VBA code - Custom Function to check if worksheet exists
There are many Functions on the internet that do the ...
Read More
custom Function
Access Excel custom split Function to delimit text
This tutorial shows how to create a custom Access Excel VBA custom Function to delimit text with the help of VBA "Split" Function instead of "Text to Columns".
Delimit text in Excel (non-VBA)
In Excel worksheet, there is a function called "Text to Columns" (Data > Text to Columns) to separate a text by delimiter. For example, Cell A1 contains "a,b,c" and after split by comma, A1 contains "a", B1 contains "b" and C1 contains "c".
An alternative way to do that is using Left Function with...
Read More
Access Excel VBA Check Prime Number using custom Function
This tutorial shows a custom Access Excel VBA Function that can check prime number, the Function returns TRUE or FALSE.
Access Excel VBA Check Prime Number using custom Function
In this tutorial, I will show a custom Access Excel Function that can check prime number, returning TRUE or FALSE. Prime number is an integer that can only be divided by 1 or itself (without remainder). Below are some examples of prime number.
1–20
2
3
5
7
11
13
17
19
23
29
31
37
41
43
47
53
59
...
Read More
VBA Access Excel Remove duplicates in text
This tutorial provides a custom Access Excel VBA Function to remove duplicates in text, parameters provide flexibility of case sensitivity and delimiter
You may also want to read:
Access Excel Scripting Dictionary store unique array item
VBA Access Excel remove duplicates in text
This tutorial is to help you to remove duplicates in text (in a Cell), but it is not about removing duplicated Cell value in a column. To remove duplicated Cell value in a column, highlight the column, navigate ...
Read More
Custom VBA Excel Access Networkdays Function
This tutorial explains how to create a custom Excel Access Networkdays Function to simulate Excel Networkdays Function, exclude holiday and weekend
Why do we need Access Networkdays Function?
As of Access 2013 version, there is no Access Networkdays Function available, the function is only available in Excel all versions.
In Excel , Networkdays Function is used to calculate the number of "net working days" between two days, excluding Saturday and Sunday, and include both start date and end ...
Read More