Home How to filter a VBA array on Error 2042
 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 Amy 25 Louise 30 Carl 40 Pete #N/A Jeff 32 Alyson 21 Valerie #N/A  I want to be able, when running my code, to have the following output Pete #N/A Valerie #N/A  Keep in mind that I have a lot of entries, thus do not want to use filter in Excel.