Oct 21 2021 02:08 PM
Is it possible to realign where my columns are after my macro runs? Because after my macro runs it moves columns all around when it's done so it doesn't keep the same view.
Oct 23 2021 10:36 AM - edited Oct 23 2021 10:40 AM
I figured it out with code similar to below
Sub ResetView()
Range("A2").Select
ActiveWindow.ScrollColumn = 7
ActiveWindow.Panes(2).Activate
ActiveWindow.SmallScroll ToRight:=11
End Sub