Hiding rows in Excel 2007 using macros

I am using excel 2007 on my windows xp computer and i want to know the procedure for Hiding rows in Excel 2007 using macros. Do i need to change any setting any work sheet to hide row?

A very handy feature of Excel is its ability to hide rows and columns from a sheet without affecting calculations in any way. To hide row in excel 2007 : Right click on the row header of the row to be hidden. Choose Hide from the menu. The selected row and the row number will be be hidden from view.

Follow the example given below to hide and unhide the row :

Code:

---



Sub HideShow()
Rows(6).Hidden = Not Rows(6).Hidden
End Sub

---

Hiding rows or columns in excel can be performed by selecting the row or column you wish to hide and going to Format>Row (or Column) >Hide or try the given program :

Code:

---

Sub HiddenRow()
  For Each cell In ActiveSheet.Range("Q6:Q137")
      If cell1.Value = "y" Then cell1.EntireRow.Hidden = True
  Next
End Sub

---