Visible Rows Count

Posted by: jpicard-fp on 8 September 2017, 2:45 pm EST

  • Posted 8 September 2017, 2:45 pm EST

    Hi,


     I want to know how can I get the number of visible rows in a spreadsheet.  I know there's the GetRowVisibleCount (but this method is protected, why?).  For the moment, I do a For Next and verify if the rows are visible or not, but I'm pretty sure that there's an easier way to get it.


     Regards

  • Replied 8 September 2017, 2:45 pm EST

    SheetView.GetViewportBottomRow - SheetView.GetViewportTopRow +1 should give you the visible row count

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels