Hide Row if Value in two cells is zero

[I.am.Rustam]

Hi Guys,

Please help with this VBA code.

I have values in Columns C & D - cells 20 to 40

I need to check if both values in C20 and D20; C21 and D21; C22 and D22 etc.., are zero, then hide the rows (current row that contain zero and other rows up to row 40).

I have found similar code on the forum, but this checks only one cell. Please help guys! Thanks!


Sub HideRows()
Application.ScreenUpdating = False
Application.Calculation = xlManual

For Each c In Range("C20:C40")
If c.Value = 0 Then Rows(c.Row).Hidden = True
Next

Application.Calculation = xlAutomatic
Application.ScreenUpdating = True
End Sub

[TMS]

Please Login or Register  to view this content.

[Alf]

Try

Please Login or Register  to view this content.

[I.am.Rustam]

Thanks guys!! Works great!

[Alf]

You are welcome!

Thanks for feedback and rep

Alf

[TMS]

Ditto. You're welcome. Thanks for the rep.

[tia8632]

HI I have the same issue

but I cant see the code you have got

I want to hide the row on cell range G29:G245 and Cell range I29:I245

if the value on both G29 and I29 or G30 and I30 are zero or give an error

and after it has done that sheet it coninues to the next sheet

the code I have so far is

Sub HideRows()
Dim cell As Range
For Each cell In Range("G29:G245")
If Not IsEmpty(cell) Then
If cell.Value = 0 Then
cell.EntireRow.Hidden = True
End If
Next
End Sub


Please please help

[tia8632]

HI I have the same issue

but I cant see the code you have got

I want to hide the row on cell range G29:G245 and Cell range I29:I245

if the value on both G29 and I29 or G30 and I30 are zero or give an error

and after it has done that sheet it coninues to the next sheet

the code I have so far is

Sub HideRows()
Dim cell As Range
For Each cell In Range("G29:G245")
If Not IsEmpty(cell) Then
If cell.Value = 0 Then
cell.EntireRow.Hidden = True
End If
Next
End Sub


Please please help

[TMS]

Hello, and welcome to the forum.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.