Speed issues with VBA function

**zemigsan** · 10-18-2013, 02:40 AM

Hi,

I have this simple function to basically calculate the average % of difference between the values in two different columns. The function is working fine but the problem is that I need to use it on more than 100 cells and it is running very very slow.

Do you know if there is something I can do in the code to speed it up?

Thank you,

Jose

Please Login or Register  to view this content.

**ARGK** · 10-18-2013, 08:59 AM

Hi
You could try this.
At the start of your code after the Sub add a new line:

Application.ScreenUpdating=False

and at the end of your code before the End Sub add this line:

Application.ScreenUpdating=True

This may help.
Good luck.
Tony

**Izandol** · 10-18-2013, 09:45 AM

You may switch this:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

If you can post a workbook with sample data and showing how you use the function we may get better speeds still.

**zemigsan** · 10-22-2013, 10:24 PM

Please Login or Register  to view this content.

You can download an example file here:

https://dl.dropboxusercontent.com/u/.../example2.xlsm

Any help in getting it faster would be awesome!

Thank you

Jose