User Posts: Al Arafat Siddique
0
How to Send Email from Excel with Body Using a Macro (with Easy Steps)
-1

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 ...

0
[Fixed!] Excel File Not Opening on Double Click (8 Possible Solutions)
-1

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. ...

0
Excel VBA: Unprotect Workbook with Password (7 Practical Examples)
-1

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 ...

0
Excel VBA: Unprotect All Sheets (4 Suitable Examples)
-1

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 ...

0
How to Forecast Sales Using Regression Analysis in Excel (3 Methods)
-1

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 ...

0
Excel VBA: Replace Character in String by Position (4 Effective Ways)
-1

This article illustrates how to replace a character in a string by position using VBA in Excel with 4 effective approaches. We’ll use Excel’s built-in ...

0
How to Create a Database That Updates Automatically in Excel
-1

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 ...

0
Excel VBA: Open Word Document and Paste (3 Suitable Examples)
-1

This article illustrates how to open a new or existing word document from Excel and paste data into it using VBA with 3 different examples. We’ll use Excel’s ...

0
How to Import Text File to Excel Using VBA (3 Easy Ways)
-1

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 ...

0
Excel Macro to Save as PDF with Filename from Cell Value (2 Examples)
0

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 ...

0
How to Import Text File with Multiple Delimiters into Excel (3 Methods)
-1

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 ...

0
Excel VBA: Split First Name and Last Name (3 Practical Examples)
-1

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 ...

0
Excel VBA: Split String by Character (6 Useful Examples)
-1

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 ...

0
How to Hide Blank Rows in Excel VBA (4 Useful Methods)
-1

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 ...

0
Excel VBA: Get Row and Column Number from Cell Address (4 Methods)
0

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 ...

Browsing All Comments By: Al Arafat Siddique

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo