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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>