How do i hide rows if a condition is met
 

Hi There,

Hopefully a simple one for somebody out there. I want to be able to
hide 2 rows of data if a condition is met (whether it be yes/no or
true/flase) Not sure what the easiest way to do this is and would
appreciate the help.

Thank you

Tony

How do i hide rows if a condition is met
 

Something like this

If Range("A1").Value = "X" Then
Columns("H:I").Hidden = True
End If

or more succinctly

Columns("H:I").Hidden = (Range("A1").Value = "X")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"tony__77" wrote in message
oups.com...
Hi There,

Hopefully a simple one for somebody out there. I want to be able to
hide 2 rows of data if a condition is met (whether it be yes/no or
true/flase) Not sure what the easiest way to do this is and would
appreciate the help.

Thank you

Tony