Speed up spreadsheet

[Malcolm torishi]

Can anyone help please,
I have just added a picture vlookup into by spreadsheet that has now made the spreadsheet run so slow, some times I am waiting up to 15 seconds to move the cursor around the spread sheet. I have in 2 of my 20 or so VBA codes added the following, which did help speed it up but it’s still slow and very frustrating. Does any know how to speed the spreadsheet up back to normal speed
thank you

Application.ScreenUpdating = False
Application.DisplayStatusBar = False
Application.EnableEvents = False

CODE HERE

Application.ScreenUpdating = True
Application.DisplayStatusBar = True
Application.EnableEvents = True

 

[Joe4]

I have in 2 of my 20 or so VBA codes added the following

Why not in all 20? That may help speed things up.

Disabling calculations in the same manner until the end of the code will also help speed things up:

Application.Calculation = xlCalculationManual
...
Application.Calculation = xlCalculationAutomatic

It is not just that, there are other things you can do to speed things up.
In general, you should not be selecting ranges very often in your code. It is usually unnecessary, and slows the code down.
And, you should avoid (or limit) loops, if you can, as loops are resource hogs and will slow the code down.

As to other specifics on speeding up the code, we would need to see your code, and have an understanding of how much data we are dealing with, in order to offer other specific suggestions.

 

[Malcolm torishi]

Are you suggesting just the calculation manual and automatic application as above in all my 20 or so other VBA codes only or also include what I have do to 2 of my codes , screen, display and enable applications .

 

[Joe4]

Do all 4 things in all 20 procedures.

 

[Malcolm torishi]

Do all 4 things in all 20 procedures.

X
Thank you

 

[Joe4]

You are welcome.

If that doesn't help, then you will need to look at the other things I mentioned.
If you need help with that part, you will need to include the code that is slow, and let us know how much data it is running against.

 

[Malcolm torishi]

Will do thanks again