Al Arafat Siddique

You have pictures in a specific folder and want to insert one of these pictures in your Excel worksheet.   Go to the Developer tab. Click ...

Introduction to the INDIRECT Function in Excel We can use  the INDIRECT function to get a valid cell reference from a cell value that is stored as a text ...

How to Write Code in the Visual Basic Editor Go to the Developer tab from the Excel Ribbon. Click the Visual Basic option. In the Visual Basic ...

How to Create a Drop-Down List in Excel STEPS: Select a cell (E3, in this example) on which we’ll create the drop-down list. Go to the Data ...

This article illustrates 3 different methods to get the last day of the current, past, or future month from a specific starting date using VBA code in Excel. ...

Method 1 - Change the Default Date & Time Format to dd/mm/yyyy hh:mm:ss in Excel When we add a date in a cell of an Excel worksheet, it stores it in its ...

Method 1 - Use of VBA Len Function to Count Characters in a Cell in Excel The LEN function in VBA Excel returns the number of characters in a text or string. ...

If we remove conditional formatting from cells where it has been applied, Excel also removes the cell formats. In this article, we will demonstrate 2 different ...

The dataset showcases a course registration form with 6 different courses. Using a Code in the Visual Basic Editor Go to the Developer tab. ...

This article illustrates how to unlock cells in Excel without a password with 4 different methods. Excel allows the feature to lock cells with passwords to ...

How to Use Code in the Visual Basic Editor Go to the Developer tab from the Excel ribbon. Click on the Visual Basic option. In the Visual ...

We’ve used a dataset that contains a sale list of a super shop. The dataset has a bunch of empty cells and we want to find them before performing any ...

In this article, we’ll illustrate how to delete a sheet if it exists from a workbook using VBA in Excel with 4 examples. As deleting worksheets is a common ...

In this article, we’ll illustrate how to delete multiple columns by number using VBA code in Excel with 4 different examples. As deleting columns is a common ...

Example 1 - Use the TODAY Function to Create a Day Countdown in Excel Here is a common template of the TODAY formula. We’re going to make a countdown for the ...