Bottom Scroll Row (2000)

Topic

New Reply

ActiveWindow.ScrollRow returns the row number that appears at the top of the active window. How can I get the row number that appears at the bottom of the active window? TIA –Sam

Reply | Quote

Replies

Sam,

This ought to do it….

Sub WhichRowAtBottom()
Dim LastVisRow As Long

With ActiveWindow.VisibleRange
LastVisRow = .Rows(.Rows.Count).Row
End With
MsgBox LastVisRow
End Sub

Regards,

Jim Cone
San Francisco, CA

Reply | Quote

Ah, VisibleRange! Why didn’t I see that? Thanks! –Sam

Reply | Quote