hide a row

[cgriff]

can I hide a row base on a condition of a cell in another row

I dont want to make the row height zero
any ideas

Thanks in advance

 

[Mark W.]

Hiding a row is accomplished by setting its Height to 0. have you considered using an Advanced AutoFilter perhaps inconjunction with a Custom View?

 

[cgriff]

Thanks for that if this is the best way how can I unhide the row

Cheers

 

[lenze]

Mark is correct, but you can accomplish this with code. Place this in the Sheet module

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$3" Then
If Target.Text = "hide" Then Range("$A$5").EntireRow.Hidden = True
If Target.Text<> "hide" Then Range("$A$5").EntireRow.Hidden = False
End If
End Sub

This will hide row 5 whenever "hide" is entered in B3. Adjust as needed

Edit: you maight also want to look at this thread
http://216.92.17.166/board/viewtopic.php?topic=24792&forum=2
This message was edited by lenze on 2002-10-10 16:29

 

[cgriff]

Thanks lenze
can you tell me the code to hide cells in a different sheet

 

[lenze]

Untested but try using

Sheet2.Range("$A$5).EntireRow.Hidden etc

or Sheets("SheetName").Range("$S$5").EntireRow etc

Edit: you may have to Activate the sheet in the code.
This message was edited by lenze on 2002-10-10 17:58