Al Arafat Siddique, BSc, Naval Architecture and Marine Engineering, Bangladesh University of Engineering and Technology, has worked on the ExcelDemy project for two years. He has written over 85+ articles for ExcelDemy. Currently, he is working as a software developer. He is leading a team of six members to develop Microsoft Office Add-ins, extending Office applications to interact with office documents. Other assigned projects to his team include creating AI-based products and online conversion tools using the latest web technologies.
This article illustrates 11 easy steps to send an email from Excel with a body using a macro. We’ll be using the Microsoft Outlook under the hood by accessing ...
This article illustrates how to fix the issue of not opening an Excel file on double click with 8 possible solutions. The issue can be caused for many reasons. ...
This article illustrates how to unprotect a workbook that is protected with a password using VBA in Excel with 7 suitable examples. Excel allows the feature to ...
This article illustrates 4 suitable examples to unprotect all sheets in a workbook in Excel using VBA. Excel allows the feature to protect sheets with or ...
The following article illustrates 3 different methods to forecast sales by using regression analysis in Excel. We’ll find the regression line equation of the ...
This article illustrates how to create a database in Excel that updates automatically with the help of 4 useful methods. It’s an important feature required ...
This article illustrates how to import a text file to Excel using VBA code with 3 suitable examples. We’ll use Excel’s built-in Split, InStr, and Replace ...
This article illustrates 2 different examples to save an active sheet as a PDF with a filename that comes from a cell value using a Macro in Excel. We’ll use ...
This article illustrates how to import Text File data with multiple delimiters into an Excel worksheet using 3 different methods. We’ll use Excel’s built-in ...
This article illustrates several approaches that split a full name into its first name and last name components using VBA code in Excel. We’ll use Excel’s ...
This article illustrates how to split a string that is separated by a character using the Split function in Excel VBA. We’ll configure different arguments of ...
This article illustrates how to hide rows that are entirely blank or have blank cells in them using VBA code in Excel. Here we’ll use Excel’s built-in ...
This article illustrates how to get the row and column number from cell address using VBA code in Excel. We’re going to use several built-in functions to ...
This article illustrates 3 examples of removing duplicates by comparing multiple columns using VBA in Excel. Here we’ll use Excel’s built-in ...
This article illustrates 4 examples of random number generators with no duplicates using VBA in Excel. Here we’ll use Excel’s built-in Rnd function to ...
ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems.
Contact | Privacy Policy | TOS