Hiding rows in Excel 2007 using macros

[sam007]

Sponsored Links

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?

[Macarenas]

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.

[vishodhan]

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

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

[JonathanD]

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 :

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