Hide row

[Richard]

After date is entered in Column D of the same row. How
would you hide that row?

 

[theillknight]

To hide a column, you have three options:

1) Ctrl-0 (the number, not the letter)
2) Right-click on the column and choose 'Hide'
3) Click on any cell in the column, go to Format - Column - Hide.

For a row, it's a similar process except the hotkey is Ctrl-9

 

[Guest]

a was finda looking for a vba function

-----Original Message-----

To hide a column, you have three options:

1) Ctrl-0 (the number, not the letter)
2) Right-click on the column and choose 'Hide'
3) Click on any cell in the column, go to Format - Column - Hide.

For a row, it's a similar process except the hotkey is Ctrl-9.
--------------
theillknight's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=10991
View this thread: http://www.excelforum.com/showthread.php?threadid=270298

.

 

[Dave Peterson]

rightclick on the worksheet tab that should have this behavior.
select view code and paste this into the code window:

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Cells.Count > 1 Then Exit Sub
If Intersect(Target, Me.Range("D")) Is Nothing Then Exit Sub

If Target.Value = "" Then
'do nothing
Else
Target.EntireRow.Hidden = True
End If

End Sub