Macros & Excel VBA

How to Hide Rows Based on Criteria with VBA in Excel: 15 Suitable Methods

Method 1 - Embed VBA to Hide a Single Row in Excel Steps: Press Alt + F11 on your keyboard or go to the tab Developer -> Visual Basic to ...

How to Extract Specific Data from PDF to Excel Using VBA

  Extract Specific Data from PDF to Excel Using VBA (Code) Sub Extract_Data_from_PDF() Set MyWorksheet = ...

How to Save an Active Sheet as a PDF with a Filename from Cell Value Using Macro in Excel

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

Print a Cell Range to PDF with VBA in Excel (5 Easy Methods)

Suppose you have the following dataset. Method 1 - Define a Range to Print to PDF and use a Cell Value as the PDF Name Steps: Decide ...

Print to PDF and Email Using VBA in Excel: 2 Useful Cases

Method 1 - Print to PDF and Email for Single Worksheet ➜ Open a module by clicking Developer > Visual Basic (or press ALT + F11). ➜ Go to ...

Excel VBA: Transpose Multiple Rows in Group to Columns

In Microsoft Excel, you may face various situations where you need to transpose multiple rows to columns. Now, you can also do this with the manual ...

How to Open a Word Document and Replace Text with Excel VBA (6 Examples)

In the following sections, we will provide six examples of how to open a Word document and replace text using VBA in Excel. Some things to ...

Excel VBA: Delete Same Sheet from Multiple Workbooks

In Microsoft Excel, we may face a situation where we have to delete sheets from multiple workbooks. We can do this manually. But this process becomes ...

Excel VBA: Create Invoice and Save PDF Format (with Quick Steps)

Create an Invoice and Save it in the PDF Format with Excel VBA (Quick View) Private Sub Create_invoice_save_pdf() 'for invoice number ...

Excel VBA: Pull Data Automatically from a Website (2 Methods)

  Excel VBA to Pull Data Automatically from a Website (Quick View) Sub Pull_Data_from_Website() Website_Address = "https://exceldemy.com" ...

VBA to Generate Multiple Lines in Email Body in Excel: 2 Methods

Method 1 - Embed VBA Macro to Generate Multiple Lines in Email Body in Excel Steps: Press Alt + F11 on your keyboard or go to the tab Developer ...

How to Split First Name and Last Name with Excel VBA – 3 Examples

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

How to Sum a Range of Cells in a Row Using Excel VBA (6 Methods)

To demonstrate our methods, we have a dataset with three columns: “Fruit,” “March Sale,” and “April Sale.” Method 1 - Using the FormulaR1C1 ...

How to Split Date and Time Using VBA in Excel – 2 Methods

Quick View: Sub Split_Date_and_Time() Date_with_Time = CDate(InputBox("Enter the Date with Time: ")) Separated_Date = Int(Date_with_Time) ...

Excel VBA: Split String by Character: 6 Useful Methods

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo