I have a range of values in Excel that I want to filter on #N/A. Since my range is of large size, I want to create an array in VBA and filter on #N/A (or Error 2042). For example, with the following data
I want to be able, when running my code, to have the following output
Keep in mind that I have a lot of entries, thus do not want to use filter in Excel.