Why do you need a Collection?

How to declare a Collection

Adding items

Inserting items

Get the number of items in a Collection

Removing items

Comparison 1: Read from a worksheet to a collection

Reading from a worksheet to a collection

Reading from a worksheet to an array

Comparison 2: Reading specific rows from a worksheet

Reading specific rows to a collection

Reading selected rows to an array

Comparison 3: Inserting Items

Inserting items into a collection

Inserting items into an array

Comparison 4: Updating item values

Updating items in a collection

Updating items in an array

Summary of differences between an array and a collection

Current Region

Reading from the worksheet

Passing a Collection to another Sub

Writing from a Collection to a worksheet

Reading the data header to the Collection

The FOR EACH Loop

The Standard For Loop

Using Step to read specific parts of the collection

Reading a collection in reverse order

Speed Test Results: FOR vs FOR EACH

Introduction

Declaring the Dictionary and Collection

Adding an item

Retrieving an item

Check if an item exists

Updating a value

Accessing an item by position

Reading from a worksheet to a collection

Creating a Class Module

How to use the Class Module

Using the Class Object with a Collection

Write from the class objects to a worksheet

Excel VBA - Custom Collections

Creating a Custom Collection

Basic Methods of a Collection

Referencing Items in a Collection

Referencing Items Using a key

Looping Over Items in a Collection

A Problem with Untyped Collections

Using Class Modules with Collections

Adding Items to a Collection in a Loop

Creating Public Collections

What is a Collection?

Examples of Related and Unrelated Values

Collection Methods

Adding new items to a collection

Adding Items without a Key

Removing duplicates using VBA

Variables used

Declare the Collection

VBA Looping Code

Conclusion

Opening a Workbook

What is a Collection?

Worksheets

Refer to Collections

The Count Property

Using the Immediate Window

Referring to a Collection in VBA

Specifying the Container

Clearing the Contents of the Immediate Window

Referencing Objects in a Collection

Video Outline

Adding Objects to a Collection

Add Items

Syntax

Variables

Create a Class

The Add Method within the Collection

Add an Item before or After

Method for Emptying the Contents of Our Collection to the Immediate Window

The for each Loop To Iterate over Our Collection

Print Our Collection Count

Introduction

How to use Arrays with Ranges

Arrays vs Dictionaries/Collections

Example 2: Unique values - Array

Example 2B: Using Transpose

Collection basics

Example 2: Unique values - Collection

Dictionary Basics

Example 2: Unique - Dictionary

Example 3: Sum Data Dictionary

Example 4: Sum Multiple fields

Intro

Creating the Collection

Difference between Collections and Arrays

Running the Subroutine

Removing an Item from a Collection

Adding an object to a Collection

Using the Code Builder to Populate the Event

Using a function that returns a Collection

Populating a Collection

Conclusion

Introduction

Basic Variables

Let and Set

VBA Objects

Using Set and New

Set New Example

Setting one object to another

VBA Objects Recap

Conclusion