Al Arafat Siddique

Step 1 - Set the Object Reference to Microsoft Outlook Go to the Developer tab on the Ribbon. Click Visual Basic. In the visual basic window, ...

Solution 1 - Uncheck the “Ignore other applications that use DDE” Option The dynamic data exchange (DDE) protocol is one of the methods for transferring data ...

Method 1 - Unprotect a Single Workbook with a Password in Excel VBA Task: Unprotect the workbook named workbook_1.xlsx inside the Exceldemy folder using VBA ...

Below is a dataset with four protected worksheets representing sale details for the first four months of the year. We cannot change any data on the worksheets ...

Definition of Regression Analysis Regression analysis is a powerful statistical method used to analyze the relationship between two or more variables in a ...

Watch Video - Create a Database That Updates Automatically in Excel Method 1 - Extract Data from the Web to Create a Database That Updates ...

Below, we have a dataset in a comma-separated text file. The dataset represents sale details for a shop. Each piece of data is separated by a comma. We want to ...

Writing Code in Visual Basic Editor Steps: Go to the Developer tab from the Excel Ribbon. Click the Visual Basic option. In the Visual ...

The sample dataset represents sale details for a shop. The data is separated by either a comma or a semicolon. We want to import this data from the Text File ...

Introduction: The VBA Split Function: is used to split a string into substrings. The function returns a zero-based one-dimensional array. Each element of ...

Method 1 - Split Words of a String by Space Character  Task: Split a text string in cell B3 by space character and output the substrings in cells D3: I3 (the ...

Below is a dataset of the sale details for different products. It contains a couple of blank rows that we will hide using simple VBA code. The Range.EntireRow ...

How to Write Code in the Visual Basic Editor To get row and column numbers from cell addresses, we need to open and write VBA code in the Visual Basic ...

Method 1 - Remove Duplicates Comparing Specified Multiple Columns Using VBA in Excel Task: We want to remove duplicate students from the dataset by comparing ...

Enter a Code in the Visual Basic Editor To generate random numbers with no duplicates, open Visual Basic Editor and use a VBA code.  Go to Developer ...