| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to hide and unhide based on criteria
Hi I am a newbie to excel macros, and wanted to know if anyone could
help create a macro which would hide rows if any string existed in one specific column. For example if column C had any text in it throughout the workbook, those entire rows would be hidden, leaving those with blanks cells in C free to work with. Also an unhide macro would be nice, once the user is done work with the wookbook, so all rows are visable again to compare. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro to hide and unhide based on criteria
You might prefer to use
datafilterautofilteretc -- Don Guillett SalesAid Software wrote in message oups.com... Hi I am a newbie to excel macros, and wanted to know if anyone could help create a macro which would hide rows if any string existed in one specific column. For example if column C had any text in it throughout the workbook, those entire rows would be hidden, leaving those with blanks cells in C free to work with. Also an unhide macro would be nice, once the user is done work with the wookbook, so all rows are visable again to compare. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HELP!! Unhide Sheet with Macro and focus on other sheet | Excel Discussion (Misc queries) | |||
| hide rows based on cell value | New Users to Excel | |||
| Hide Unhide Hide again | New Users to Excel | |||
| How do I hide or unhide zero value columns/rows USING A MACRO? | Excel Discussion (Misc queries) | |||
| How Do I Hide A Row (if a condition is true) using a Macro ? | Excel Worksheet Functions | |||
Linear Mode
