Hide/Unhide a row in Excel

  • Thread starter Thread starter Mohanasundaram
  • Start date Start date
M

Mohanasundaram

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.
 
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
 
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 (e-mail address removed)
 
Thanks a lot
-----Original Message-----
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 (e-mail address removed)






.
 
Back
Top