Dear Flavio, Dear All Surely code does not 'just stop'. When there is an error the execution stops in the line with the error and this is highlighted in yellow. A dialog box appears with a message describing the error. The clue to the error is in the message. Flavio - Is this not happening. ? Derek +++ >________________________________ > From: Gary Morris <gwmorris@att.net> >To: "ExcelVBA@yahoogroups.com" <ExcelVBA@yahoogroups.com> >Sent: Monday, 30 April 2012, 19:00 >Subject: Re: [ExcelVBA] VBA stops to run > > > >David's about right. All I can see is either permissions or >there is some code that doesn't work....
Senin, 30 April 2012
Re: [ExcelVBA] VBA stops to run
David's about right. All I can see is either permissions or there is some code that doesn't work. In my experience, if code doesn't finish running it's because there is something wrong or not quite right with it. If you rely on recording and then modifying macros, the code that Excel creates may not do EXACTLY what you intended, or it may do only the specific commands you gave while recording. Adding loops and conditions is always something to do carefully, and to really do it right always make sure you understand the generated code (IF you recorded it). It usually takes me a while to not only figure out what it's doing, but how to go about changing it. If you are NOT recording the...
RE: [ExcelVBA] VBA stops to run
Possibilities are: The workbook is opened as read-only You do not have write permissions in the directory holding the workbook There is a macro in the workbook which is triggered when you save it The workbook is not the active workbook at the time you issue the command The code saves the workbook but the next command is defective Try stepping through the code and checking what happens then. Best Regards David Grugeon Excel VBA Group Moderator -----Original Message----- From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf Of Flavio Sent: Saturday, 28 April 2012 1:00 AM To: ExcelVBA@yahoogroups.com Subject: [ExcelVBA] VBA stops to run Good morning...
]] XL-mania [[ Digest Number 2380
Microsoft Excel Community Messages In This Digest (8 Messages) 1.1. File - rules_and_tips From: XL-mania@yahoogroups.com 2a. Re: alert bila data telah ada From: Cabang Nasi Padang 2b. Re: alert bila data telah ada From: Kid Mr. 3a. Re: Auto Hide Row From: Markonah 4a. Re: Auto Filter was limited From: Markonah ...
Langganan:
Postingan (Atom)