Autofilter tp leave out #N/A in macro
Solved/Closed
Related:
- Vba filter not equal to
- Spell number in excel without macro - Guide
- Run macro when cell value changes - Guide
- Macro excel download - Download - Spreadsheets
- Automatically Run Macro from a calculated cell value change ✓ - Excel Forum
- Excel macro to create new sheet based on value in cells - Guide
6 replies
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
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(...))