Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditionally Hide Rows
HI All,
How do I conditionally rows if a certain cell = 0? For example, if any cell within range BA5:BA37 =0 then hide row. Any help will be appreciated. Thanks. James |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditionally Hide Rows
How about just selecting that column and doing data|Filter|autofilter.
Then you can show cells not equal to 0. wrote: HI All, How do I conditionally rows if a certain cell = 0? For example, if any cell within range BA5:BA37 =0 then hide row. Any help will be appreciated. Thanks. James -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditionally Hide Rows
On May 11, 9:03 am, Dave Peterson wrote:
How about just selecting that column and doing data|Filter|autofilter. Then you can show cells not equal to 0. wrote: HI All, How do I conditionally rows if a certain cell = 0? For example, if any cell within range BA5:BA37 =0 then hide row. Any help will be appreciated. Thanks. James -- Dave Peterson Thanks for the help, but I've tried that and it does not refresh when I import new data. I'm looking for something that updates when I import new data. Thanks for you help so far. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditionally Hide Rows
If you are importing your data with MSQuery, then do it with a macro and
include the Filtering feature Dave described. Vaya con Dios, Chuck, CABGx3 " wrote: On May 11, 9:03 am, Dave Peterson wrote: How about just selecting that column and doing data|Filter|autofilter. Then you can show cells not equal to 0. wrote: HI All, How do I conditionally rows if a certain cell = 0? For example, if any cell within range BA5:BA37 =0 then hide row. Any help will be appreciated. Thanks. James -- Dave Peterson Thanks for the help, but I've tried that and it does not refresh when I import new data. I'm looking for something that updates when I import new data. Thanks for you help so far. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditionally Hide Rows
You could use a macro with a Worksheet_Change event like the following:
Private Sub Worksheet_Change(ByVal Target As Range) Const MyRng = "BA5:BA37" Dim c As Range For Each c In Range(MyRng) If c.Address = Target.Address Then If Target.Value = 0 Then Target.EntireRow.Hidden = True Else Target.EntireRow.Hidden = False End If End If Next c End Sub Right-click on the tab of the sheet where you want to use this, then select "View code". Paste the function into the worksheet code module when the VB Editor appears. Hope this helps, Hutch " wrote: HI All, How do I conditionally rows if a certain cell = 0? For example, if any cell within range BA5:BA37 =0 then hide row. Any help will be appreciated. Thanks. James |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditionally Hide Rows
Should I select the drop drop in "General" or "Worksheet"? Thanks.
James |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditionally Hide Rows
Worksheet. A "Worksheet_SelectionChange" subroutine may appear by default
with no code. Ignore it and paste the code I sent in the same module below it. Hutch " wrote: Should I select the drop drop in "General" or "Worksheet"? Thanks. James |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Way to conditionally hide rows? | Excel Worksheet Functions | |||
a way to conditionally hide tabs in a range | Excel Discussion (Misc queries) | |||
Is there a way to conditionally hide a row? | Excel Discussion (Misc queries) | |||
Conditionally Hide Rows | Excel Discussion (Misc queries) | |||
Excel - if cells = 0, how to conditionally hide rows in chart | Excel Worksheet Functions |