VBA infinite Loop

Questions ArchiveCategory: ProgrammingVBA infinite Loop
dane collins asked 1 year ago

I created a solution for problem two in the VBA Loops hw but I noticed if the columns only have one value that the program will run inftinetly. any idea on how not fix that/do I need to fix it?

1 Answers
Matt McCord answered 1 year ago

Make sure that your condition (Do While, Do Until, For, For Each) is being met. If the condition will never be achieved then this will cause the infinite loop. I would also recommend putting in the DoEvents to make sure that you can exit out in case of an infinite loop.

Your Answer

6 + 14 =