LAST.ERROR

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