<div>
Activewindow.visiblerange<br />
<br />
Thanks a lot
</div>


<div>
<div class="content wysiwyg-content">
Activewindow.scrollrow returns the first row visible on screen. How do I get the last row?
</div>
</div>


Activewindow.scrollrow returns the first row visible on screen. How do I get the last row?

Getting the last row on screen

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