Hello

I know it is possible to make a macro running in VBA faster - I have seen theis info somewhere, but I have forgoten hot to make it. I hopy somebody can help me: when the wotkbook is opened the macro runs automatically and it jumps on different location and it doesn't look very nice.
I think the solution is to prevent refreshing on the screen. How to make it?

Thanks a lot