Macro Sheets Only
Returns the reference to the cell where the last macro sheet error occurred. If no error has occurred, LAST.ERROR returns the #N/A error value. Use LAST.ERROR in conjunction with the REFTEXT function to quickly locate errors.
Syntax
LAST.ERROR( )
Related Function
ERROR Specifies what action to take if an error is encountered while a macro is running
List of Information Functions