Hi All

I wonder if any kind soul can help me......

I'm trying to automate putting column L to the far left (ie cant see cols A-K, but not wanting them hidden) and then putting Freezepane on at col M.

But everytime I code to move the activecell from say col B to AY, Col L disappears behind the row heading, or if then I select col L the screen then shows from col E?? Yet if I manually move the curser using the arrow keys I can get Col L to be the first left hand Col.

Many thanks

Badger