Getting the last row on screen

Saqib Husain, Syed
Saqib Husain, Syed used Ask the Experts™
on
Activewindow.scrollrow returns the first row visible on screen. How do I get the last row?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Commented: 
MsgBox Range(Split(ActiveWindow.VisibleRange.Address, ":")(1)).Row

Open in new window


Kris
Saqib Husain, SyedEngineer

Author

Commented:
Activewindow.visiblerange

Thanks a lot

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial