I Need Arrays, Boss!
- Introduction and Workbooks Download
- What's An Array - Overview and Sheet Demonstration
- What's An Array - Technical Demonstration With Code
- More On One-Dimensional Declaration
- Declaring Non-Traditional Boundaries and Thresholds
- Data Types in Arrays
- Cells Object Lesson and Comparison
- Multidimensional Arrays
Populating and Manipulating Arrays
- Populating an Array with Array() Function
- Populating an Array with Split() Function
- Section 02 Exercise
- Exercise - Solution
- Populating an Array with a Range Via (FOR NEXT) Loop
- Populating an Array with a Range Via (FOR EACH) Loop
- Populating an Array with a Range Directly
- Getting the Start and End Boundaries
- Looping Through a 1 Dimensional Array
- FOR EACH Loop Through an Array
- Looping Through a 2 Dimensional Array
- Subscript Out Of Range - Reasons for Run-time error 9
- Static vs Dynamic
- Change The Size (on the Fly)!
- Resize Array Without Losing Everything
- Returning Array to a Worksheet
- BONUS - Real World Speed Comparison - Case Study
- Storing Array Data...
- Storing Array in Names
- Accessing Array from Invisible Name in Names Manager
Functions, Arrays and You - A Magical Combination
- Using WorksheetFunctions on Arrays
- Passing an Array Into a Function or Sub
- Passing an Array Into a Function or Sub (Advanced Example)
- Returning an Array FROM a Function
- IsArray Function
- Filter() Function
- Join() Function
- Join() Function - Practical Example
- The Erase Method
- Transposing an Array
- Determining Worksheet Range from Array Size
- Dynamic Sorting 01 - 2d Array On Sheet Dynamically
- Dynamic Sorting 02 - Dynamic Sort Record, Syntax and Explanation
- BONUS - ReDim Preserving a Multi Dimensional Array - Part 1
- BONUS - ReDim Preserving a MD Array - 02 Transpose Method
- BONUS - ReDim Preserving a MD Array - 03 Custom Function
Custom Functions - Because Microsoft Can't Think Of It All
- Bubble Sorting
- Quick Sorting
- BONUS LECTURE
