| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
macro to hide a row when a cell contains a value
I have an excel sheet that contains multiple rows. I want to be able to
hide/unhide the rows that contain "C" (complete) when there is a "C" in column P when I click on the command button that contains the macro |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
macro to hide a row when a cell contains a value
Sub HideMe()
n = Cells(Rows.Count, "P").End(xlUp).Row For i = 1 To n If Cells(i, "P").Value = "C" Then Rows(i).EntireRow.Hidden = True End If Next End Sub -- Gary''s Student - gsnu200814 "InfoNeeded" wrote: I have an excel sheet that contains multiple rows. I want to be able to hide/unhide the rows that contain "C" (complete) when there is a "C" in column P when I click on the command button that contains the macro |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide and lock cell formulas without affecting Macro? | Excel Discussion (Misc queries) | |||
| Hide a Macro | Excel Discussion (Misc queries) | |||
| macro to hide row with 0.00 | Excel Worksheet Functions | |||
| Formula or Macro to hide a row based on a cell value | Excel Discussion (Misc queries) | |||
| macro to hide rows if cell is blank | Excel Worksheet Functions | |||
Linear Mode
