Latest Posts From Al Arafat Siddique
This article illustrates how to define a dynamic range in Excel based on a cell value using VBA code. We’re going to explain 3 different examples to define and ...
Al Arafat Siddique
This article illustrates several examples to hide or unhide columns in Excel based on drop-down list selection. We’ll use VBA code to first set conditions to ...
This article illustrates how to convert a date in Excel to dd/mm/yyyy hh:mm:ss format using the TEXT function, Custom Formatting, and VBA code with suitable ...
This article illustrates 5 different methods to count the number of characters in a cell or a range of cells using VBA code in Excel. These methods will ...
In this article, we would show 2 different ways to remove conditional formatting but keep the format in Excel. We frequently use conditional formatting rules ...
This article illustrates how to check, set, and manipulate the form control checkbox value using VBA code in Excel. The form control checkboxes are very handy ...
This article illustrates how to format a cell as text using VBA code in Excel with 3 different methods. With the help of the Text and Format functions, and the ...
This article illustrates how to find the next empty cell in a range using VBA code in Excel with 4 different examples. We’ll use Excel’s built-in functions in ...
In this article, we’ll discuss how to use the built–in functions in Excel to create a day countdown of a future event. This day countdown is commonly used to ...
This article illustrates 5 different methods to copy unique values to another worksheet in the same workbook in Excel. Working with a dataset with duplicate ...
This article explains 3 methods to convert unix timestamp to date in Excel. The Unix timestamp format is widely used in different operating and file systems. ...
In this article, we’ll discuss several methods to convert string to number in Excel VBA. We’ll see how to use the built-in functions and create a custom ...
In this article, we’ll discuss how to calculate the future value of an investment in Excel when the CAGR is known. This is also known as the Reverse Compound ...
Method 1 - Calculate Elapsed Time in Excel by Subtracting Two Date Values In this example, we’re going to calculate the elapsed time of World War 2. Here, ...
In this article, we’ll discuss several examples of using the exponential growth formula in Excel. In one method we’ll explain how to use one of Excel’s ...
