January 27, 2014
Using the data found in the excel-dynamic-arrays.xlsx workbook from https://www.myonlinetraininghu.....mic-arrays I have successfully used all of the new Dynamic Array functions within VBA apart from the FILTER function.
Every time I try to use FILTER I get the "Subscript out of range" error. Has anyone managed to use this worksheet function in VBA?
November 1, 2018