Can I unhide all rows?

Can I unhide all rows?

Posted by: craigreilly on 30 January 2018, 2:05 pm EST

• 

  craigreilly

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 30 January 2018, 2:05 pm EST

  Would like to unhide all rows quickly when a user wants to - without having to cycle thru each row and set each row to this state.

• 

  craigreilly

  • Post Options:
  • Link
    Copy

  Posted 30 January 2018, 2:19 pm EST

  → Tried “FpSpread1.ActiveSheet.Rows(-1).Visible = True” without success

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 31 January 2018, 7:22 am EST

  Hello,

  You can use the following line of code to unhide all rows:

  
  FpSpread1.ActiveSheet.Rows(0, FpSpread1.ActiveSheet.Rows.Count-1).Visible = True
  
  

  Thanks,
  
  Mohit