Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide/Unhide a row in Excel
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide/Unhide a row in Excel
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide/Unhide a row in Excel
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide/Unhide a row in Excel
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 "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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Hide & Unhide Columns/Rows | Excel Discussion (Misc queries) | |||
Excel Hide/Unhide | Excel Discussion (Misc queries) | |||
How do I hide and unhide worksheets in Excel 2007? | Excel Discussion (Misc queries) | |||
How do I hide or unhide row and column heading in Excel? | Excel Worksheet Functions | |||
Excel 97 hide unhide problem | Excel Discussion (Misc queries) |