Hide Row If Question

[donjamin]

I need a macro or formula that would hide a row in the event that the following would be true:

I2=H2

and repeat to I3=H3 and so on.

all the way down to Row 731.. Also how would i go about unhiding to view later?

If possible. I really appreciate any help.

Thanks

 

[JackDanIce]

Welcome to the board.
Try:

Sub quack()
 
Dim i as Long
 
Application.ScreenUpdating = False
 
For i = 2 to Range("I" & Rows.Count).End(xlUp).Row
  If Range("I" & i) = Range("H" & i) Then Rows.(i).EntireRow.Hidden = True
Next i
 
Application.ScreenUpdating = True
 
End Sub

 

[donjamin]

Not sure if I entered it incorrectly, but it asked me to debug and then it didn't work.

 

[vaskov17]

This -> Rows.(i).EntireRow.Hidden
should be -> Rows(i).EntireRow.Hidden

 

[donjamin]

When I try to enter this I get a run time error 28, out of stack space.

 

[donjamin]

I have a feeling I'm not entering it correctly, so if someone can shed some light it'd be appreciated!

 

[AlphaFrog]

Put this in any empty column in row 2 and then copy it down the column. For this example, say that coulmn is column J and you put it in cell J2 on down

=I2=H2

The formulas will return TRUE or FALSE

• Select column J
• Select from the menu Data\Filter\Autofilter
• That will put a dropdown list in cell J1
• Select from The J1 dropdown list FALSE
• That will hide all the rows where I = H

 

[donjamin]

Wow awesome Alpha, I appreciate it!