| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Macro to Hide Rows with Certain Values
Hi:
I want to use macro to hide rows with certain values. For example, cell C7 has a value of "E- Express" and cell C8 has a value of "R- Regular". I want to write a macro to hide rows only with "E- Express" and "R- Regular in column "C" starting at C7 and end at C751. I don't want to this manually. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically hide rows with no values | Excel Discussion (Misc queries) | |||
| How do I hide rows in a pivot table with zero values? | Excel Worksheet Functions | |||
| Can anyone tell me how to hide rows that have 0 values and text. | Charts and Charting in Excel | |||
| How do i hide rows in pivot table that has zero values? | Excel Discussion (Misc queries) | |||
| hide rows with macro | Excel Discussion (Misc queries) | |||
![Gap from Target[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
