Announcement

Collapse
No announcement yet.

Conditional hiding rows

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Conditional hiding rows

    Hi,

    I have a sheet and need to do the following:

    If cell R3=Flase i need to hide row 79
    If cell S3=Flase i need to hide row 80

    and so on

    Any help?

    Thanks

  • #2

    If Range("R3").Value = "False" Then
    Rows("79:79").EntireRow.Hidden = True
    ElseIf
    Range("S3").Value = "FAlse" Then
    Rows("80:80").EntireRow.Hidden = False
    End If

    Comment

    Working...
    X