What is the syntax to hide/unhide rows?

Rows(“<row number>”).EntireRow.Hidden = <true or false>
‘examples
Rows(“1:5”).EntireRow.Hidden=true ‘hides rows 1,2,3,4,5
Rows(“6”).EntireRow.Hidden=false ‘unhides row 6
Advertisements