<div>
To scroll the active window to a specific cell (that cell is located in the top left corner of the window) use the ActiveWindow.ScrollColumn and ActiveWindow.ScrollRow properties as illustrated in the example code below.<br />
<br />
&nbsp; &nbsp;ActiveWindow.ScrollRow = 20<br />
&nbsp; &nbsp;ActiveWindow.ScrollRow = ActiveCell.Row<br />
&nbsp; &nbsp;ActiveWindow.ScrollColumn = 10<br />
&nbsp; &nbsp;ActiveWindow.ScrollColumn = ActiveCell.Column<br />
&nbsp; &nbsp;ActiveWindow.ScrollColumn = Range(&quot;X10&quot;).Column<br />
<br />
Note that since the ScrollRow and ScrollColumn belong to the ActiveWindow property, there is no way to scroll a worksheet unless it is active.<br />
<br />
Kevin
</div>


To scroll the active window to a specific cell (that cell is located in the top left corner of the window) use the ActiveWindow.ScrollColumn and ActiveWindow.ScrollRow properties as illustrated in the example code below.

   ActiveWindow.ScrollRow = 20
   ActiveWindow.ScrollRow = ActiveCell.Row
   ActiveWindow.ScrollColumn = 10
   ActiveWindow.ScrollColumn = ActiveCell.Column
   ActiveWindow.ScrollColumn = Range("X10").Column

Note that since the ScrollRow and ScrollColumn belong to the ActiveWindow property, there is no way to scroll a worksheet unless it is active.

Kevin

<div>
Perfect Kevin, that's perfect :)<br />
thank you
</div>


Perfect Kevin, that's perfect :)
thank you

<div>
Hello Kevin, here is another one if you are interested<br />
<a href="https://www.experts-exchange.com/questions/28163247/vba-activate.html" rel="ugc">https://www.experts-exchange.com/questions/28163247/vba-activate.html</a>
</div>


Hello Kevin, here is another one if you are interested
https://www.experts-exchange.com/questions/28163247/vba-activate.html [https://www.experts-exchange.com/questions/28163247/vba-activate.html]

<div>
<div class="content wysiwyg-content">
Hello To all Gurus,<br />
<br />
Is there a way to do this in VBA? I am dealing with a lot of user edited excel files<br />
<br />
I want to loop through all excel files in a folder. <br />
Go through each sheet in each file and set the vertical scroll bar to look at the first row.<br />
Then save the file<br />
Go to next file in folder<br />
<br />
How to do this l?<br />
<br />
<br />
Thanks
</div>
</div>


Hello To all Gurus,

Is there a way to do this in VBA? I am dealing with a lot of user edited excel files

I want to loop through all excel files in a folder. 
Go through each sheet in each file and set the vertical scroll bar to look at the first row.
Then save the file
Go to next file in folder

How to do this l?


Thanks

excel Vba Scroll To top

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

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