UsefulGyaan Has Posted the Following On 07-10-2013 09:56 AM:

When an error occurs in your VBA project then it is extremely valuable to know what caused it so that you know how to counter it. Erl function returns the line number where an error occurs. For using this, your lines of code should be numbered (The line numbers don’t have to be in any […]

[url=http://usefulgyaan.wordpress.com/2013/07/10/tracking-the-line-number-where-error-occurs/]VBA Trick of the Week :: Tracking the Line Number Where Error Occurs