Stuck in an infinite loop!!

zookeepertx

Well-known Member
Joined
May 27, 2011
Messages
586
Office Version
  1. 365
Platform
  1. Windows
I currently have a macro stuck in an infinite loop! I've done Alt/Esc about 3 times and it's not breaking out. I tried Ctrl/Esc, Alt/End and Ctrl/End & it isn't helping.

Anybody have any ideas?

Thank you!!
 
How many rows/columns are you looping through? & are you deleting anything during the loop?

I'm looping through - in this case - 15 rows and 26-28 columns both of which will vary anytime this report is pulled
It goes to a new row, then loops through column 26 through whatever the last column is. Based on the data in those cells, the row might be deleted. Then it moves on to the next row.
 
Upvote 0

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
That shouldn't take long, so it does sound like you created a permanent loop.
 
Upvote 0
Looks like. It's running through with no problem now.

Thanks!
 
Upvote 0

Forum statistics

Threads
1,223,904
Messages
6,175,295
Members
452,632
Latest member
jladair

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top