Latest Posts From Al Arafat Siddique
This article illustrates how to cut a column and then insert it again based on different criteria using VBA in Excel. Normally, we can do the same task using a ...
Al Arafat Siddique
This article illustrates how to open a hyperlink in the Google Chrome browser using VBA code in Excel. We’ll use the Shell function to define the browser path ...
This article illustrates 3 methods to auto-sort data in Excel without macros. We’ll use the SORT, VLOOPUP, INDEX, and MATCH functions to sort a specific range ...
This article illustrates 3 different methods to select and set the print area of a dataset to selection using VBA code in Excel. We’ll also modify our code to ...
This article illustrates 4 different examples to filter a dataset based on a cell value that is on another sheet using VBA code in Excel. We’ll use Excel’s ...
This article illustrates how to format a number as currency with two decimal places using VBA code in Excel. This helps to display numbers in our dataset as ...
In this article, we’ll illustrate how to extract data from multiple Excel files that are in a specific folder into a single workbook using Macro. The extracted ...
In this article, we’ll illustrate how to loop through columns in a predefined range using VBA code in Excel with 5 suitable examples. Let’s dive into them to ...
This article illustrates how to change the font color for part of a text in Excel using VBA code. We are going to use Excel’s built-in property and color ...
In this article, we’ll illustrate how to insert data into an Excel table using VBA code. With the help of Excel’s built-in properties and methods, we can ...
In this article, we’ll show how to navigate from one sheet to another by creating a drop-down list hyperlink to another sheet in Excel. We’ll use the HYPERLINK ...
This article illustrates how to format a number with commas using built-in functions in VBA Excel. We commonly use a comma to display a thousand separators in ...
This article illustrates how to use the dynamic named range feature in an Excel chart. Without the feature, we have to readjust the source data of a chart ...
This article illustrates how to insert a picture in Excel from the storage folder using VBA code with 2 different methods. We’ll be able to insert single or ...
This article illustrates how to convert formula in text format to a real formula to make calculations by using the INDIRECT function in Excel. The INDIRECT ...
