You are here Create UDF function return array with resize Create UDF function return array with resize

Create UDF function return array with resize

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.