Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically hide column or row if a cell value meets criteria
I need a macro or formula that will automatically hide a row or column
based on an entry in a specific cell. For instance, =IF(D2="",*****,D2) with ***** being the formula or =IF(C3=0,Rows("3:3").Select,Selection.EntireRow.Hi dden=True,C3) of course this isn't working but something like this would be great Thanks so much for your continued assistance. Don |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically hide column or row if a cell value meets criteria
Private Sub Worksheet_Calculate()
On Error GoTo stoppit Application.EnableEvents = False With Me.Range("C3") If .Value = 0 Then .EntireRow.Hidden = True Else .EntireRow.Hidden = False End If End With stoppit: Application.EnableEvents = True End Sub Gord Dibben MS Excel MVP On Wed, 4 Jun 2008 06:56:37 -0700 (PDT), wrote: I need a macro or formula that will automatically hide a row or column based on an entry in a specific cell. For instance, =IF(D2="",*****,D2) with ***** being the formula or =IF(C3=0,Rows("3:3").Select,Selection.EntireRow.Hi dden=True,C3) of course this isn't working but something like this would be great Thanks so much for your continued assistance. Don |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically hide column or row if a cell value meets criteri
I am having a similiar problem. I wanted to hide a row everytime a task is
complete. For example, anytime in colum F shows status complete I want to hide row. 1. What would be the best macro for this function? 2. How do I add a macro to excel? Thanks in advance! "Gord Dibben" wrote: Private Sub Worksheet_Calculate() On Error GoTo stoppit Application.EnableEvents = False With Me.Range("C3") If .Value = 0 Then .EntireRow.Hidden = True Else .EntireRow.Hidden = False End If End With stoppit: Application.EnableEvents = True End Sub Gord Dibben MS Excel MVP On Wed, 4 Jun 2008 06:56:37 -0700 (PDT), wrote: I need a macro or formula that will automatically hide a row or column based on an entry in a specific cell. For instance, =IF(D2="",*****,D2) with ***** being the formula or =IF(C3=0,Rows("3:3").Select,Selection.EntireRow.Hi dden=True,C3) of course this isn't working but something like this would be great Thanks so much for your continued assistance. Don |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically hide column or row if a cell value meets criteri
How would the "status complete" get entered into column F?
If manually just use this code Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo enditall Application.EnableEvents = False If Target.Cells.Column = 6 And _ Target.Value = "complete" Then Target.EntireRow.Hidden = True End If enditall: Application.EnableEvents = True End Sub This is sheet event code. Right-click on the sheet tab and "View Code". Copy/paste into that sheet module. Edit to suit then Alt + q to return to the Excel sheet. Enter "complete"(no quotes) in F1 and see row1 disappear(hide). Gord On Tue, 10 Jun 2008 12:10:00 -0700, Mindy wrote: I am having a similiar problem. I wanted to hide a row everytime a task is complete. For example, anytime in colum F shows status complete I want to hide row. 1. What would be the best macro for this function? 2. How do I add a macro to excel? Thanks in advance! "Gord Dibben" wrote: Private Sub Worksheet_Calculate() On Error GoTo stoppit Application.EnableEvents = False With Me.Range("C3") If .Value = 0 Then .EntireRow.Hidden = True Else .EntireRow.Hidden = False End If End With stoppit: Application.EnableEvents = True End Sub Gord Dibben MS Excel MVP On Wed, 4 Jun 2008 06:56:37 -0700 (PDT), wrote: I need a macro or formula that will automatically hide a row or column based on an entry in a specific cell. For instance, =IF(D2="",*****,D2) with ***** being the formula or =IF(C3=0,Rows("3:3").Select,Selection.EntireRow.Hi dden=True,C3) of course this isn't working but something like this would be great Thanks so much for your continued assistance. Don |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting a Value IF a cell meets a criteria | Excel Discussion (Misc queries) | |||
How do I count in column A when it meets all criteria in three col | Excel Worksheet Functions | |||
How can I get a cell to Flash if it meets a certain criteria in Ex | Excel Worksheet Functions | |||
How do I go to the next cell that meets criteria | Excel Discussion (Misc queries) | |||
Highlight a row automatically if a cell meets certain criteria | Excel Worksheet Functions |