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):

Please Login or Register  to view this content.

[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.