Hiding rows
 

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

Hiding rows
 

couple of ways
sorthide

for each c
if ucase(c)="HIDE" then c.entirerow.hidden=true
next c
--
Don Guillett
SalesAid Software

"ChiragP" wrote in message
...
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

Hiding rows
 

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



"ChiragP" wrote:

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