Istiyak Member Mar 4, 2012 #1 Can we negotiate VBA on any error while VBA is executing. Regards Istiyak
K keymaster New Member Mar 5, 2012 #2 You can... there are few excellent error handling mechanism. ON ERROR GOTO X if you write this line at the beginning of your code, it will take you to X whenever there is an error. ON ERROR RESUME NEXT if you use this, any errors will be ignored and next line of code will be executed. ON ERROR GOTO 0 will reset the error handler. play with these to learn how to use them.
You can... there are few excellent error handling mechanism. ON ERROR GOTO X if you write this line at the beginning of your code, it will take you to X whenever there is an error. ON ERROR RESUME NEXT if you use this, any errors will be ignored and next line of code will be executed. ON ERROR GOTO 0 will reset the error handler. play with these to learn how to use them.
Istiyak Member Mar 5, 2012 #3 Hey Chandoo, m lucky man... you had replied.. Will play and get back to u if any query... Regards Istiyak
Hey Chandoo, m lucky man... you had replied.. Will play and get back to u if any query... Regards Istiyak