VBA Code to Hide Excel 2010 Rows

[mjd1947]

I need a macro that will hide an entire row in Excel 2010 based on the value in one column. I have found other macros but they perform very slowly with 2010. The sheet has about 1300 rows.

Thanks in advance.

 

[mintjulep]

Why not use filter?

 

[Andrzejek]

A better place to ask this question would be VBA Visual Basic for Applications (Microsoft)
But, try this:

Column A:[tt]
Header
1
2
3
4
5
6
7
8
9
10
[/tt]

Dim i As Integer
i = 2
Do While Range("A" & i).Value <> ""
    If Range("A" & i).Value = "4" Then
        Rows(i & ":" & i).EntireRow.Hidden = True
    End If
    i = i + 1
Loop

Macro will hide the Row with the value 4


Have fun.

---- Andy

 

[kjv1611]

A filter is more likely to perform more quickly than using VBA, as mentioned by mintjulep.

Any reason you need to use VBA in this scneario?

If you want a filter, but want it automated, you can look into creating and managing List Objects and Query Tables in Excel VBA.


"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57