Hiding only Specific Rows using VBA

[Grothgar]

Hi All;

I have a spreadsheet where I have a simple formula. The formula is IF($A2=$B$2,1,0), and then I drag down to the bottom of the spreadsheet, so whenever it matches it shows a 1.
Now, what I need to do using VBA is hide all the rows that do not have 1's on them. I know how to start the VBA, but not how to finish

Dim LR as Long
LR = Range("A2").End(xlDown).Row

Because that will allow me to only select the row field that I want to do the Macro on.
So, how do I go about hiding rows that only have 0's in them.

Thanks

 

[SteveO59L]

Why not simply use a filter?

 

[Grothgar]

Why not simply use a filter?

You know... sometimes I look for a more complicated measure than what is needed! DOH!