Convert Range To Array Excel VBA Macro

Get the Excel VBA Objects Guide here: https://excelmacroclass.blogspot.com/... Arrays are used to store sets of data. A range with data in Excel can be stored in a two-dimensional (2D) array. A column or row are also Range objects and have by default 2 dimensions (one of which has only one element – either the column or the row). In this video we see how to put data from a range into a 2D array, and data from a single column or row into a 1D array. Find more content and numerous macro examples and other Excel VBA learning materials in the Excel Macro Class blog under the direct link: https://excelmacroclass.blogspot.com/ And yet, if you want more, you can find various Excel templates, dashboards, and applications of different nature in the other blogs of the Excel Macro Mania saga: Excel Macro Fun (https://excelmacrofun.blogspot.com/) Excel Macro Business (https://excelmacrobusiness.blogspot.com/) Excel Macro Sports (https://excelmacrosports.blogspot.com/)