Wise Red Owl Journal

welcome to this YSL tutorial in this video we're going to talk about using arrays in Excel VBA so we'll start by explaining what an array actually is and how it differs from our basic data type variable we'll show you how you can declare a fixed size array and then how to write information to and read data from that array well then move on to show you how you can loop over an array as a slightly quicker way of reading information from it and also how you can clear the content of an array by erasing it but the second part of the video will then move on to some more sophisticated array types including multi dimension arrays and dynamic arrays so as usual there's quite a lot to do let's get started in VBA an array is like a variable which allows you to store more than one value using the same variable name so in previous videos in this series we've seen lots of examples of using basic data