Excel with VB filtering inquiry

[Manne]

Hello everyone,

Good Day!

I am new to posting, forums and I would like to ask for help.
I have been working on this assignment in Excel. I have tried to create button on top of my worksheet that will filter the desired category but it run so slow

see below the code.

Private Sub CommandButton1_ Click()

Rows.Hidden = False
Counter = Range("A1").Val ue + 4
For i = 4 To Counter
If Cells(i, 14).Value <> "CJSL" Then
Rows(i).Hidden = True
End If
Next

End Sub



If someone can help me enhance my excel vbcode to make it faster it would be extremely appreciate it. If not can someone direct me in the right direction.

Thanks Everyone,
Manne

[bartonc]

You'll probably want to repost in the Visual Basic Forum for faster response. And while you are browsing the site, check out our Posting Guidelines. Thanks.