Excel - Code Execution has been interrupted

GrilledCheese

Board Regular
Joined
Apr 23, 2014
Messages
75
Hi. I have VBA coding in an Excel 2010 workbook. I have vlookups in the workbook linking to a source workbook. In the source workbook, I accidentally hit "ESC" on the keyboard and got the message "Code Execution has been interrupted." Since then, the VBA code does not run. How do I get the VBA code to fire again?
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

GrilledCheese

Board Regular
Joined
Apr 23, 2014
Messages
75
I figured it out. When the "Code Execution has been interrupted" message popped up on the screen when I hit "ESC" on the keyboard while the VBA fired, I clicked on "Debug" and then the F5 key (Run). Clicking on the F5 key will continued to fire the code where it broke.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,522
Messages
5,529,330
Members
409,863
Latest member
stacy09
Top