Excel Macro Mastery
  • EMMArtboard 4-100
  • Member Area
      • Start here
          • How to use the Membership Area
          • The Blueprint for Learning Excel VBA
      • Downloads
          • Cheat Sheets
      • Webinars
          • All Webinars

          • Most Popular
            • How to Design a VBA Application Like a Pro (Video)
            • 5 VBA Hacks Everyone Should know (Video)
            • How to use Class Modules in Excel VBA (Video)

          • Data Structures VBA
            • How to use Arrays to Optimize Your VBA Code(Video)
            • Excel VBA Collections – A Complete Guide (Video)
            • How to use the VBA Dictionary Like a Pro(Video)
          • Businesswoman pressing business type of modern buttons with virtHow to Copy Data Between ANY Two Sheets(Video)
      • Account Information
        • Subscription and Payment details
        • Lost your Password?

  • VBA Articles
  • Courses
  • Webinars
  • About
How to Use Arrays to Optimize Code(Video)

How to Use Arrays to Optimize Code(Video)

by Paul Kelly | | Data Structures VBA, Vault Video

Webinar Number: W0066   Arrays are possibly the most important element of Excel VBA. Not only do they make your code more readable, they also allow you to process data thousands of times faster than using Ranges. If you haven’t used arrays before, then they...
How to Use Arrays to Optimize Code(Video)

How to Use Arrays to Optimize Code(Video)

by Paul Kelly | | Data Structures VBA, Vault Video

Webinar Number: W0062 Arrays are possibly the most important element of Excel VBA. Not only do they make your code more readable, they also allow the you to process data thousands of times faster than using Ranges. If you haven’t used arrays before then you may...
When to use Arrays, Collections and Dictionaries (Video)

When to use Arrays, Collections and Dictionaries (Video)

by Paul Kelly | | Data Structures VBA, Vault Video

Webinar Number: W0018 In this webinar, I cover using Arrays, Collections and Dictionaries. When should each be used? The pro and cons of each and a guide to selecting the correct one to use.   Downloads Download the workbook here.   Related Links VBA Arrays...
Excel VBA Array – The Complete Guide

Excel VBA Array – The Complete Guide

by Paul Kelly | | Data Structures VBA, Most Popular

This post provides an in-depth look at the VBA array which is a very important part of the Excel VBA programming language. It covers everything you need to know about the VBA array. We will start by seeing what exactly is the VBA Array is and why you need it. Below...

You are not logged in

You are not currently logged in.








» Register
» Lost your Password?
Check out my YouTube channel...

  • Facebook
  • Twitter
  • Instagram
  • RSS

Designed by Elegant Themes | Powered by WordPress

We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.