Iserror Macro
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Iserror Macro as PDF for free.
More details
- Words: 86
- Pages: 2
1) 2) 3) 4) 5)
Save this file on your desktop and then open it Open the model where you want to use the ISERROR formula Highlight the range you want to use the formula Hit Ctrl+e to run the macro for ISERROR formula If you want to undo please use Ctrl+z
***
Please note this will work for only fomulas where cell reference is done and not for the below: #DIV/0! 50 Err:502
Text Not a cel reference formula comments
and not for the below:
Save this file on your desktop and then open it Open the model where you want to use the ISERROR formula Highlight the range you want to use the formula Hit Ctrl+e to run the macro for ISERROR formula If you want to undo please use Ctrl+z
***
Please note this will work for only fomulas where cell reference is done and not for the below: #DIV/0! 50 Err:502
Text Not a cel reference formula comments
and not for the below:
