weird code execution

micro · May 24th, 2002, 11:45 PM

Is it possible for code to execute correctly, and then execute differently with no changes to any existing code? and if so, what are some possible causes. the question seems silly, but I am experiencing this. there are no other apps open, and no other workbooks open.

thank you in advance

Joe Was · May 25th, 2002, 12:26 AM

If the code works by modifing rows or columns. Or, if the code does an action that sets a condition then the code may not work at all the next time on the same sheet or workbook. To test this run your code then Exit without saving and re-run, if the code runs then the code is OK?
If you re-run the code again on the same sheet and it does not run right, then it still may be all right, if it did what it should the first time, or you may have bad code that is doing something to the workbook that you did not count on!
Without seeing the code or knowing what you are doing it is hard to say? JSW

[ This Message was edited by: Joe Was on 2002-05-25 21:51 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 24th, 2002, 11:45 PM	#1
micro New Member Join Date: May 2002 Posts: 4	Is it possible for code to execute correctly, and then execute differently with no changes to any existing code? and if so, what are some possible causes. the question seems silly, but I am experiencing this. there are no other apps open, and no other workbooks open. thank you in advance

May 25th, 2002, 12:26 AM	#2
Joe Was MrExcel MVP Join Date: Feb 2002 Location: Central Florida, USA Posts: 7,541	If the code works by modifing rows or columns. Or, if the code does an action that sets a condition then the code may not work at all the next time on the same sheet or workbook. To test this run your code then Exit without saving and re-run, if the code runs then the code is OK? If you re-run the code again on the same sheet and it does not run right, then it still may be all right, if it did what it should the first time, or you may have bad code that is doing something to the workbook that you did not count on! Without seeing the code or knowing what you are doing it is hard to say? JSW [ This Message was edited by: Joe Was on 2002-05-25 21:51 ]