<div>
You're welcome and I'm glad I was able to help.<br />
<br />
In <a href="https://www.experts-exchange.com/M_258447.html" rel="ugc">my profile</a> you'll find links to some articles I've written that may interest you.<br />
Marty - MVP 2009 to 2014
</div>


You're welcome and I'm glad I was able to help.

In my profile [https://www.experts-exchange.com/M_258447.html] you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014

<div>
Thanks Marty. Appreciate the help<br />
Murray
</div>


<div>
<div class="content wysiwyg-content">
Hi<br />
I am trying to use the following VBA code to split an Excel window and then scroll down to row 100<br />
in the bottom section of the screen but it scrolls in the top section. How do I scroll the bottom section<br />
<br />
&nbsp; &nbsp;With ActiveWindow<br />
&nbsp; &nbsp; &nbsp; &nbsp; .SplitColumn = 0<br />
&nbsp; &nbsp; &nbsp; &nbsp; .SplitRow = 14<br />
&nbsp; &nbsp; End With<br />
&nbsp; &nbsp; Range(&quot;B19&quot;).Select<br />
&nbsp; &nbsp; ActiveWindow.SmallScroll Down:=100
</div>
</div>


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

Excel VBA  Scroll top section of a split window

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.