Program won't stop
I tried to use a program that builds a telephone directory. It was built
a couple of years ago, on Vista. When I switched it over to Win 7, it works (I've stepped through it using Break commands) but it just won't stop. The area of interest is the following From...Next statements. For m= 1 to 26 (Letters in the alphabet) .... .... .... Next End End Sub For some reason it won't stop at 26 and just keeps going. Is this a Win 7 problem, or is there something else that could have happened. Jim Berglund |
Program won't stop
I don't believe a simple for loop wound give yo this problem. I bet if yo eliminate all the code inside the for loop the problem will stop. Sub Test For m = 1 to 26 a = m next m msgbox("finished for Loop") End Sub I will repeat my tow tips when ever there are unexplained problems 1) Comment out all On Error statements until you isolate the problem 2) Enable trapping on ALL Errors. Go to VBA menu Tools - Options - General - Error Trapping - break on All errors -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=171606 Microsoft Office Help |
Program won't stop
Can you post your code that is inside the loop? Without it we can't
determine the problem exactly, thus we are left to guess the problem. Do you have anything in the loop that changes the value of m? -- Cheers, Ryan "jazzzbo" wrote: I tried to use a program that builds a telephone directory. It was built a couple of years ago, on Vista. When I switched it over to Win 7, it works (I've stepped through it using Break commands) but it just won't stop. The area of interest is the following From...Next statements. For m= 1 to 26 (Letters in the alphabet) .... .... .... Next End End Sub For some reason it won't stop at 26 and just keeps going. Is this a Win 7 problem, or is there something else that could have happened. Jim Berglund . |
All times are GMT +1. The time now is 02:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com