Programming the array function with the property of automatically receiving all the elements of the array into the sheet and automatically scaling to the size of the array is a special technology in the A-Tools Add-in such as the BS_SQL, BS_VLOOKUP,... A-Tools has opened an API library that allows you to know how to program VBA to create array functions with properties similar to those in A-Tools.