Autofilter tp leave out #N/A in macro
Solved/Closed
Related:
- Vba filter not equal to
- Why does facebook refresh when i leave the app - Guide
- How to leave a close friends story - Instagram Forum
- Macro for number to words in excel - Guide
- Excel online macro - Guide
- How to leave business account on tiktok ✓ - TikTok Forum
6 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 27, 2010 at 04:58 PM
May 27, 2010 at 04:58 PM
The best and most easy way of this answer would be
start macro recorder
apply the filter
stop the recorder.
now you would have the code to use
Also you can do what Trowa suggest
=IF(ISERROR(vlookup(...)), "PROJ NOT FOUND", VLOOKUP(...))
start macro recorder
apply the filter
stop the recorder.
now you would have the code to use
Also you can do what Trowa suggest
=IF(ISERROR(vlookup(...)), "PROJ NOT FOUND", VLOOKUP(...))