[RESOLVED] Excel 2010 freezing when renaming multiple sheets

[stephan2531]

I'm not sure how to do that.

[TnTinMN]

I'm not sure how to do that.

Assuming that one was meant for me.

Go to that line in the code and press the F9 key (that key will toggle the breakpoint on/off); you should see a reddish dot show up at the left of the line. When you run your code, the execution will now stop at that line.

Now open the "Immediate Window" (Ctrl-G) and enter: ? Range("B2").Value
The "?" tells it to print out the value.

You can use the "F8" key to step through the successive lines of code looking for the source of the issue or press "F5" to resume processing.

[stephan2531]

vbfbryce, is there a delay code or something that I can insert there to pause the macro so the URL can return the data before it continues?