Hide and Unhide Rows

[Legacy 287389]

hi there,

I am battling to get rows to hide when vale in column A is zero,and to unhde when value is greater than zero. Any help will be greatly appreciated. Thank you...

I wanted to attach a spreadsheet, but cannot see the icon to use for this?

 

[Alan_P]

Hi Juriemagic,

This code should do what you are asking for...

Sub HideRw()

Dim LastRw As Long
Dim i As Long

LastRw = Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Row

For i = 1 To LastRw

    If Sheets("Sheet1").Cells(i, "A").Value < 1 Then
        Rows(i).Hidden = True
    ElseIf Sheets("Sheet1").Cells(i, "A").Value >= 1 Then
        Rows(i).Hidden = False
    End If

Next

End Sub

Hope this helps,
Cheers,
Alan.

 

[Smitty]

Welcome to the Board!

How are the cell values changing (via formula or manually)?

For posting a screen shot you can follow the HTML Maker link in my sig.

 

[Legacy 287389]

Hi Juriemagic,

This code should do what you are asking for...

Sub HideRw()

Dim LastRw As Long
Dim i As Long

LastRw = Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Row

For i = 1 To LastRw

    If Sheets("Sheet1").Cells(i, "A").Value < 1 Then
        Rows(i).Hidden = True
    ElseIf Sheets("Sheet1").Cells(i, "A").Value >= 1 Then
        Rows(i).Hidden = False
    End If

Next

End Sub

Hope this helps,
Cheers,
Alan.

Hi Alan,

Thank you for prompt reply. The code however does not execute. What I have is the following:

2 Sheets. Graph on Sheet 2. This graph displays info from sheet 1. It a multi legend line graph. Info on sheet 1 comes from a database sheet. Data
on sheet 1 changes by aid of criteria dropdowns on sheet 2. So:, I select criteria on sheet 2 with dropdown, sheet 1 looks for the criteria in Database sheet, and populates. Graph on Sheet 2 displays data. The problem is that rows with zero data should hide on sheet 1, so that only legends with data appears on chart. Hope this will help. Thanx for your time spent on this...

 

[Legacy 287389]

Hi Smitty,

Cell values change from dropdown selection, and then via formulae...

 

[alansidman]

CrossPosted: Hide Row when Cell in column A =0 [SOLVED]

 

[Legacy 287389]

Hi, sorry...did not realize was breaking rules. I have already posted this question on Excel Forum, got some nice suggestions, but the are all working sluggishly when fired. I was only hoping for a better, smoother solution..Hide Row when Cell in column A =0 [SOLVED] - Page 2

 

[Legacy 287389]

This is the link....
Hide Row when Cell in column A =0 [SOLVED] - Page 2