Program appears to loop endlessly, have to force quit

[Danexcel]

Sorry! Forgot the code!!!

Here's the code I am using. It worked before.
I added in the section you see in it for clearing the formatting.

I don't believe that I tweaked it to cause what is happening,
but now when I run the program (from a button I made),
the excel screen flashes wildly and never seems to give the results.
I even had it run in the background for awhile while I did work in another
application, checking back on it periodically.

Is there something in my code that looks like it could be causing such an
endless loop?

Thank you!

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

You'll need to post the code of course

Rgds

[Danexcel]

Hi,

You'll need to post the code of course

Rgds

Good catch! Thanks

[shg]

You set rData to the usedrange of sheet Results, and then clear the usedrange, and then try to operate on rData, which is now cleared.

[Richard Buttrey]

Hi,

First thought is where does Range("R5").End(xlDown) take you to? If row 65536 then you are looking at a lot of cells and maybe the macro is just chuntering through.

The other instruction I'd look at is the Sheets("Results").UsedRange.Clear

I've noticed in both xl2007 and xl2003 that on occasions this can take for ever. I've never fully buttoned it down but I think its associated with the system thinking the last cell in the used range is down on row 65536. You may think the last visible cell is the last cell, but sometimes if a format, or even a cell entry which is subsequently deleted is on the last row, this persists until you delete the extraneous rows/columns and perform a Save.

HTH

[Danexcel]

Hi,

First thought is where does Range("R5").End(xlDown) take you to? If row 65536 then you are looking at a lot of cells and maybe the macro is just chuntering through.

The other instruction I'd look at is the Sheets("Results").UsedRange.Clear

I've noticed in both xl2007 and xl2003 that on occasions this can take for ever. I've never fully buttoned it down but I think its associated with the system thinking the last cell in the used range is down on row 65536. You may think the last visible cell is the last cell, but sometimes if a format, or even a cell entry which is subsequently deleted is on the last row, this persists until you delete the extraneous rows/columns and perform a Save.

HTH

Thank you. Yes, I'd like it to only go down to row 604. I tried to simply replaced the word xlDown with "R604" but I guess that's not permitted.
How do I tell the program to stop at 604?

[Richard Buttrey]

Hi,

Just use:

Please Login or Register  to view this content.

Rgds