Home How to filter a VBA array on Error 2042
Reply: 0

How to filter a VBA array on Error 2042

user550
1#
user550 Published in June 21, 2018, 8:41 am

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.

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.396339 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO