Today I tried using F8 to step through my project and it was going sooo slow. I use F8 all the time and it usually zips right through I dont know if some option was changed or what. If anyone has any suggestions please let me know. Thank you.
Today I tried using F8 to step through my project and it was going sooo slow. I use F8 all the time and it usually zips right through I dont know if some option was changed or what. If anyone has any suggestions please let me know. Thank you.
You can try setting break points (F9) at various points in your code instead of stepping. Then when you find your problem you can step in that area.
Not sure what you mean by going slow, but if you have a lot of lines a break point is a great way of getting there quick and then stepping..
what i mean by going slow is that if you hold down F8 it will process like 30 rows a sec. but mine is only doing 3 lines a sec. when I hold it down
Depending on what the code is, the workbook may be recalculating between every step, the code may be talking to the printer driver, ...
Entia non sunt multiplicanda sine necessitate
From what SHG says, you might try setting the recalculate mode to manual?
At the beginning of your macro:
at the end:Please Login or Register to view this content.
Not sure if you it will affect your macro though.Please Login or Register to view this content.
I does not seem to matter what the code is. I threw together a quick (endless) loop statement to see how fast and how many times it would loop in (lets say 5) Seconds. Usually it would be impossible to count but mine will only do 4 loops
Hey Chip, did you try restarting your computer 3 times?
Just kidding, not sure what the issue is here. Google CCleaner, maybe your computer is bogged down with old temp files. That is all I can think of if this is occurring even on a pretty much empty workbook with just a few lines of code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks