Hiding rows

[Guest]

Hi I'm hoping that someone can help.

How can I hide a row in a range.

I have a column T, and in this colum each row either has a number or hide.
Can someone please let me know what the code is to hide the rows that have
"hide" in them

Thanks

 

[Don Guillett]

couple of ways
sort>hide

for each c
if ucase(c)="HIDE" then c.entirerow.hidden=true
next c

 

[Guest]

try this:
for each cEl in range("T:T")
if cEl="Hide" then
cEl.entirerow.hidden=true
end if
next