Macros & Excel VBA

Excel VBA: If Cell Contains Value Then Return a Specified Output

In the sample dataset of examination record for Sunflower Kindergarten school, the blank cells mean that the student was absent for that particular ...

VBA to Customize Row Height in Excel (6 Methods)

In this article, we will show you how to customize row height in Excel with a VBA macro, including how to set new row heights, change row height for ...

VBA to Hide Rows in Excel (14 Methods)

In this article, we will discuss 14 different methods to hide rows in Excel based on different criteria utilizing the VBA macro. The sample ...

How to Freeze Panes with VBA in Excel (5 Ways)

  Sub Freeze_Panes_Row_and_Column() Range("C4").Select ActiveWindow.FreezePanes = True End Sub Method 1 - Freezing a Row with ...

VBA to Merge Cells in Excel (9 Methods)

In Excel, to merge multiple cells or ranges into one singular cell using VBA, the Range.Merge method is used. Range.Merge Method in Excel ...

Print to PDF in Excel VBA with the ExportAsFixedFormat Statement: 5 Examples

Method 1 - Print to PDF in Excel VBA with No Name or Path Specified We have a worksheet with the book records of a bookshop called Marin Bookstore. ...

How to Print Data with Excel VBA (A Detailed Guideline)

Download Practice Workbook VBA Print.xlsm Step 1 - Opening the VBA Editor to Print in Excel Press ALT+F11 to open the Visual Basic ...

How to Use VBA to Insert Rows in Excel – 11 Methods

Method 1 - Applying VBA to Insert a Single Row Based on Cell Text Value in Excel Consider the following dataset. Steps: Press Alt + ...

How to Sort a ListBox with VBA in Excel (A Complete Guide)

Method 1 - Sort a ListBox in a Worksheet 1.1 Creating a ListBox in an Excel Worksheet Before sorting the ListBox, let’s quickly go over how to ...

How to Sort a Table in Excel using VBA (4 Methods)

Things to Know Before Implementing VBA to Sort a Table in Excel Before implementing VBA to sort a table in Excel, there are some parameters you need ...

How to Sort a Column Using VBA in Excel (4 Methods)

Range.Sort Method in Excel VBA The Range.Sort method in Excel VBA allows you to sort a range of values. The Range object variable specifies the ...

How to Sort Range Using VBA in Excel (6 Examples)

Knowing how to sort range using VBA in Excel saves time and effort in our daily calculations. Although Excel provides a sorting facility by default, ...

How to Sort Multiple Columns with Excel VBA (3 Methods)

Sort Multiple Columns with Excel VBA (Quick View) ActiveSheet.Range("B4:D13").Sort Key1:=Range("D8"), Order1:=xlAscending Sort Multiple ...

How to Use Concatenate in Excel VBA (4 Methods)

  Download the Practice Workbook Download this practice workbook to exercise while you are reading this article. VBA Concatenate ...

How to Use VBA Val Function in Excel (7 Examples)

The VBA Val function is an Excel Text function which converts a text string into a numeric value. You can use this function in a VBA code to get the ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo