Solved VBA code to scroll beyond frozen panes

December 15, 2016 at 06:27:33
Specs: Windows 7
Can anyone tell me what is the VBA code to scroll to a particular column that is beyond the frozen panes?

I have a sheet that I have various autofilters, the sheet has columns a-h frozen. When I run a particular autofilter I want to keep the same panes frozen but I want to have column AD scrolled right next to the last frozen pane (column h).

Any help would be appreciated :-)

See More: VBA code to scroll beyond frozen panes

Report •

December 15, 2016 at 10:36:05
✔ Best Answer
Google is your friend.

ActiveWindow.ScrollColumn = 30

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question