rows("10:10").entirerow.hidden=true
rows("10:10").entirerow.hidden=false

The best way of finding out these things is to turn on the macro recorder,
do what you want, stop the recording then look at the source. You will
learn a huge amount by doing this.


--

Regards,


Bill Lunney
www.billlunney.com

"Mohanasundaram" wrote in message
...
Hi All,

I would like to hide or unhide a row in an Excel
sheet programatically. I am not good in VBA. Please tell
me how to do that.

Thanks in advance


Regards,
Mohan.