Stuck in an infinite loop!!

[zookeepertx]

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!!

 

[DanteAmor]

Could you put your code to review it?

 

[gallen]

The correct combination for interrupting code is [Ctrl] + [Break]

 

[zookeepertx]

Hi Gallen,

Okay, I just tried that 3 times and it didn't seem to make any difference.

 

[zookeepertx]

I can't; the Visual Basic window is also "stuck" and won't let me highlight and copy the code.

 

[Fluff]

Sounds like you'll have to kill it via task manager.

 

[gallen]

Failing that you will need to open task manager and end process. However you will lose any unsaved excel work.

Then you must find out why your code is in an infinite loop...

Can always post code here if you are unsure. I'm confident it's something we've all done at some point :D

 

[Fluff]

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

 

[zookeepertx]

Hi Fluff

Yeah, I finally gave up a few minutes ago and went to Task Manager and took care of it.

I was running a code where lCol was being Dimmed (is that the right word for past-tense of Dim in VBA?) but that had already been done earlier in the macro, so it had failed. So, I went to change all of the lCol to Lc and apparently, I missed one. So, I assume that if seized up trying to loop through "From j to Lc". I can't be SURE that's where the problem was because VBA window didn't show a yellow highlight showing how far the code had gotten, but that was the only thing I changed and the macro was running fine before that. (Although I was trying to adjust it, because my co-worker changed his mind about what result he wanted.)

Anyway, I'm going to recreate the adjustments (correctly this time!!) and try it again here in a minute. Keeping my fingers crossed!

Thanks!

Jenny

 

[zookeepertx]

Hi Gallen,

See my post #9 .

If it fails again I'll post back with the code (which I'm going to copy right now and paste in a Word document, LOL!)

Thanks!

Jenny