Autofilter tp leave out #N/A in macro
Solved/Closed
Related:
- Excel vba autofilter not equal to
- Number to words in excel without vba - Guide
- Enable vba in excel - Guide
- Vba case like - Guide
- Excel date format dd.mm.yyyy - Guide
- How to take screenshot in excel - Guide
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(...))