See the full list of VBA functions here: excelmacroclass.blogspot.com/p/vba-functions.html
Welcome to Excel VBA Functions Series. In this video we see the array functions ARRAY, FILTER, and JOIN, used to create an array, filter the values in the array, and join values from an array, respectively. We see several practical examples of the functions in detail. Furthermore, we see a useful line of code to convert a range into a string using the JOIN function.
Find more content and numerous macro examples and other Excel VBA learning materials in the Excel Macro Class blog under the direct link: 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 (excelmacrofun.blogspot.com/)
Excel Macro Business (excelmacrobusiness.blogspot.com/)
Excel Macro Sports (excelmacrosports.blogspot.com/)