Latest Blog Posts

Excel Slicer Multiple Columns: 3 Examples

Method 1 - Excel Slicer with Multiple Columns Find all the columns in the Excel slicer in a single column. You can see the below image. ...

Excel VBA to Call Sub with Parameters (3 Suitable Examples)

If you want to learn Visual Basic for Applications (Excel VBA), one of the most important concepts to know is Subroutines with parameters and how to ...

Using the Excel VBA Function to Return Multiple Values – 6 Methods

The image below showcases how three results can be obtained, using the ByRef argument in the Excel VBA function. Method 1 - Returning ...

How to Define a Global Array in Excel VBA – 2 Methods

This is an overview. What Is a Global Array in Excel? In VBA (Visual Basic for Applications), a global array is an array that is declared ...

Sum If Greater Than and Less Than Cell Value in Excel

Method 1 - Sum If Greater Than and Less Than from Same Value 1.1 Applying SUMIF Function for Greater Than and Less Than from Same Value You have to ...

How to Fit Long Text in One Cell in Excel – 6 Methods

Download Practice Workbook Download the worksheet here. Fit Long Text in One Cell.xlsx How to Fit Long Text in One Cell in Excel : ...

Using the VLOOKUP Functions Between Worksheets in Excel

VLOOKUP Between Worksheets in Excel: Knowledge Hub VLOOKUP and SUM Across Multiple Sheets VLOOKUP Example Between Two Sheets Perform ...

How to Use the Excel VBA Textbox to Format Dates (4 Methods)

When working with UserForms in Excel VBA, it is often necessary to format the date values displayed in TextBox controls for a better user experience. ...

Excel VBA Declare Global Variable and Assign Value: 2 Ways

Method 1 - Declare Global Variable and Assign Value in VBA There are numerous advantages to using Global variables. We will address the issues ...

Excel VBA to Select Last Row

In Excel, if we need to add a new row after the last row in a large dataset, it can become tedious and time-consuming to go to the last row. Although ...

Activeworkbook Refreshall Not Working [Solved!]

Excel VBA Refresh All Open Workbooks The ActiveWorkbook.RefreshAll method is used to refresh all the existing data connections and pivot tables in a ...

How to Use the Excel VBA INDEX MATCH Function in Another Worksheet – 3 Methods

This is an overview: The sample dataset showcases Names. Date and Quantity sold. The dataset is in sheet1 and the result sheets are sheet2 ...

How to Use Excel VBA Text to Columns Date Format (2 Examples)

The article demonstrates how to create a VBA macro that automates the Text to Columns process and converts text dates into Excel date format. ...

Using Excel VBA to Format a Number with a Leading Zero – 4 Methods

How to Launch the VBA Editor in Excel Enable the Developer tab on your ribbon. Go to the Developer tab. Select Visual Basic. Select ...

Loop Through Excel Files in Folder with VBA: 5 Suitable Examples

Method 1 - Loop Through Excel Files in Folder by Dir Function The Dir function in VBA retrieves the name of a file or folder that matches a ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo