Mohan,

Try the following to hide row 4.

ActiveSheet.Rows(4).Hidden = True
'or
ActiveSheet.Range("A4").EntireRow.Hidden = True

Change True to False to make the row visible.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.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.