Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 558
  • Last Modified:

Excel VBA Scroll top section of a split window

Hi
I am trying to use the following VBA code to split an Excel window and then scroll down to row 100
in the bottom section of the screen but it scrolls in the top section. How do I scroll the bottom section

   With ActiveWindow
        .SplitColumn = 0
        .SplitRow = 14
    End With
    Range("B19").Select
    ActiveWindow.SmallScroll Down:=100
0
Murray Brown
Asked:
Murray Brown
  • 2
  • 2
1 Solution
 
Martin LissRetired ProgrammerCommented:
With ActiveWindow
        .SplitColumn = 0
        .SplitRow = 14
    End With
    'Range("B19").Select
    ActiveWindow.Panes(3).Activate
    ActiveWindow.SmallScroll Down:=100
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
0
 
Martin LissRetired ProgrammerCommented:
You're welcome and I'm glad I was able to help.

In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks Marty. Appreciate the help
Murray
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now