How to stop the screen scrolling all over the place

I have a code which adds a column and changes the colour of the cell, the font colour, the borders etc so when an end user adds a column it does it all for them.

However, when I run the macro it all works fine but the screen scrolls all over the place because it follows what I DID when I recorded the macro.

I went into the code and deleted the activescreen scroll (least I thought I did) but it still scrolls around.


can anyone look at the code below and show me where in the code it makes the screen scroll?? can I stop it?

p.s. I left the last piece of code to obvious make the screen scroll back to the top

Please Login or Register  to view this content.

You could simply add:

Please Login or Register  to view this content.

at the start of the code and:

Please Login or Register  to view this content.

at the end. It would be better to also rewrite the code to avoid all that selecting.

It would be something like:

Please Login or Register  to view this content.

You may need to adjust some of the border code.

I'm impressed you managed to test that new code within a minute.