Please Help to fix the VBA error

[vpnvipin]

Hi Everyone,

I am struck with a error message while running a macro, I want to insert a code that will override this error msg popup and continue running a macro, Any help would be appreciated and advance tnx... here by I am attacthing error screen shot and code


vba error.PNG

Please Login or Register  to view this content.

[Pichingualas]

Please change the thread title to comply with the forum rules:

1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

[Fettertiger]

Hi,

it seems that you have an issue often refered as "phantom break points". Sometimes excel does not clean up breakpoints which causes the macro to stop. You can manualy continue using F5 which is usually not the solution you want to ask your users to do. There are different solutions to the problem. Sometimes the "clear all breakpoints" in the debug menue of the VBE does the job. Sometimes pressing CTRL + Pause + Enter while no Macro is running fixes the issue. What always works is exporting your macros to a textfile and reimporting those text files back to VBE. There is a (free) tool at http://www.appspro.com/Utilities/CodeCleaner.htm which does this automaticaly if you click the button in VBE. I used to have many users complaining about the same issue in one of my tools. Using the code cleaner solved it immideatly

Regards

Theo

[vpnvipin]

Thnx a ton Fettertiger , I will check and let u knw...