Useful Code – Skills and Automation

Visit my Youtube Channel

Use Functions With Dynamic Arrays and Dictionaries

Learn how to pass dictionaries and dynamic arrays as parameters through a function.

Select Dataset Except For Top Row

How to select a dataset minus top row

Download Attachments From Outlook Emails

We will look at 2 ways of achieving this. Direct and via Offline Saved messages

Using Arrays and Dictionaries Within Dictionaries

Explore advanced Dictionary concepts such as using Arrays and Dictionaries within a Parent Dictionary

Introduction to Dynamic Arrays

Beginner's introduction to using Dynamic Arrays.

Excel VBA: Practical Guide to Finding Unique Values

Learn how to extract unique values using advanced filter and dictionary. Many examples covered such as multiple column combination and criteria based.

Dictionary Q & A

Question and Answers from Youtube related to my videos on Dictionaries.

Excel VBA: Practical Guide to Using Dictionary

Guide to using Dictionaries in VBA. 4 awesome examples.

Excel VBA: Dealing with Excel Errors

Learn a powerful way to aggregate data using the SQL Group By clause within Excel VBA. We will also, cover some basic SQL statements. In addition, we will look at error handling.