CODEWITHSUNDEEP
vbaexcel
Satheesh47
Satheesh47

Reputation: 31

How to fix the Excel goes to Not-responding state when the Macro is running?

The Excel sheet is getting Not-responding while the Macro is running, Once the macro has run, it back to the sheet with the answers.

Upvotes: 0

Views: 3515

Answers (1)

LimaNightHawk
LimaNightHawk

Reputation: 7073

You are probably running some kind of loop. Try inserting a DoEvents somewhere in the loop and see if this helps.

Dim i As Long
For i = 1 To 1000
    ' do stuff that takes a long time

    DoEvents
Next i

Upvotes: 1

Related Questions