Quicken a marco

[Marc_w90]

Hello,
I have this bit of code that I'm using and they its performing really slowly and I'm not sure why or how to improve it.

Sub Hide_complete2014()
Application.ScreenUpdating = False
Dim cell As Range
For Each cell In Range("N1:N1000")
If (cell.Value) = "Complete" Then
cell.EntireRow.Hidden = True
End If
Next
Application.ScreenUpdating = True
End Sub

All they are doing is sorting a mass load of data the ranges and N1:N1000 could actually do with either being a count or infinitely long if possible while still running quickly.

any ideas?

Thanks
Marc

 

[Joe4]

It looks like you just want to hide rows depending on whether column N is equal to "Complete". If that is the case, instead of using VBA and Loops, you can just use Filters.

 

[Marc_w90]

Sorry I should probably elaborate on the situation.
This is in a sheet where the users are not entirely used to excel and there are other bits of code that do similar things with multiple filters.

 

[Joe4]

You can do Filters in VBA code. Try re-using the Macro Recorder and record yourself applying the filters. That will give you most of the code that you need.
If you have any issues, please post the code you come up with and explain what you need adjusted.

 

[Marc_w90]

Thanks Joe, that worked a treat. Didn't realise you could record filters.