Using The Erl () Function

When an Excel (or Word) VBA error occurs, the built-in Erl function is supposed to tell you the exact line where the error occurred, but it only works if you’ve added code line numbers to your VBA Project.

Use the VBA Line Numbers with CodeLiner toolbar to add the code line numbers. This will allow you to use the Erl function to identify the exact location of your error.

Save time finding errors! Save time adding line numbers! Download a free trial!