Using the data found in the excel-dynamic-arrays.xlsx workbook from https://www.myonlinetraininghub.com/excel-dynamic-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?
If you're trying to use Worksheetfunction.Filter, the second argument needs to be an array of True/False values and oriented the correct way (ie if you are filtering a column, you need a vertical array, whereas for a row, you need a horizontal one).
Thank you.
I created a Filter array of True and False values based on test criteria and then used that array as the second argument and it worked perfectly.
