Re: zoom widow to a selected range
Thanks for adding vba code tags. Still learning forum guidlines.
Thanks for the code suggestion. Although the custom view seems start with the correct selected column it seems to just remember the zoom level at time the view was saved. So if the macro is run when the app window is a different size or if the monitor resolution is different then the result is not correct. (however it does do it while events are enabled)
I also want this macro to run on application resize. I understand the application resize procedure so what I am trying to achieve is to resize to Columns G to M so that is what the user sees under all situations.
I guess I can disable events, run my macro and re enable events. I'm just on a mission to do this with as few lines of code as possible. In the past few days I have managed to cut most of my macros in half. It's kind of my way to gain knowledge of vba. Try, Try and Try again!
So although I can use my current project, I'd still like to find an answer and if I do figure it out I'll certainly reply here.