Tidying/ Simplifying Code

Hi everyone,

I am looking for some advice in simplifying, tiding up some codes and implementing commenting on the VBA itself.

What I have attached is a sample static data of the stock prices of 3 companies. I have also created a macro button to run the code to calculate the average.

The codes will be plugged for dynamic numbers/cells very soon, as this is just a testing application so therefore I created a dynamic looping code for testing.

I was wondering if anyone could help me read the my codes especially on the Average part and help me simplify if there's any possibility to do so.

Use these codes and your sheet will update almost instantaneously without all that flickering and unnecessary cell selections, I put the three cleanup macros into one since it appears you do them together every time:

Please Login or Register  to view this content.

JBeaucaire,

This code

Please Login or Register  to view this content.

Can be changed to

Please Login or Register  to view this content.

VBA Noob

Remember, I converted you multiple macros into one? The critical line in that macro to eliminate screen flickering is:

Please Login or Register  to view this content.

Add that to the top of all the macros you call.

Also, look a the way the macro cleanup was simplified after you recorded it. You can do that with all your macros as you add more ranges.

Originally Posted by bomberchia

JBeaucaire, thanks for that reminder! I've updated it.

If I inserted that into the VBA code, will it interfere with the refresh button where it paste special values from the live data to that static page?

No. All it does is do all the work without making you watch what it's doing.