Thread: how hide a Row / Column

if the user enter a 0 in a the column A (or other) i want hide the row

VBA Noob(M)
Forum Moderator write me:
--------------------------------------------------------
Right click sheet tab > select view code > paste in the below.

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1:Az1000")) Is Nothing Then
    Select Case Target.Value
        Case 0: Target.RowHeight = 0
        Case Else: Target.RowHeight = 5
    End Select
End If
End Sub

--------------------------------------------------------
but inplace of:

  Target.RowHeight = 0

i want hide the row. thanks

much thansk friends