Hiding Rows VBA

[aeewing]

Hello!

I need to create a macro that will automatically hide a range of cells if "X" is displayed in column A.

The column with x's named range is Crit. If you need anymore information please let me know. Itd been 4 years since I worked with VBA so I dont remember much of anything.

Thanks!
Alex

[JBeaucaire]

We don't need you to remember VBA, we need you to provide all the information for at least one complete example. (BTW, you can't hide cells, only rows/columns)

"If I put an "X" in A1 I would like to HIDE rows 2:4"

Put this code into the sheet module where you need this to occur automatically (right-click tab, select View Code):

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)

    If Not Intersect(Target, [A1]) Is Nothing Then
        Rows("2:4").Hidden = [A1] = "x"
    End If
    
End Sub

[aeewing]

This is perfect thank you!

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.