Visible Rows Count

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

  • Posted 8 September 2017, 2:45 pm EST

    <P> 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.</P>
    <P> Regards</P>
  • Replied 8 September 2017, 2:45 pm EST

    <p>SheetView.GetViewportBottomRow - SheetView.GetViewportTopRow +1 should give you the visible row count</p>
Need extra support?

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

Learn More

Forum Channels