Hi guys,
I am having a process time issue. Basically I have a summary table that reads from the lines of various other worksheets. Many of these will be blank - but the number of blank lines will change and so I have the following code in the worksheet:
This just cycles through the 189 row, checking if the total is zero and hiding the row if it is, unhiding it if it isn't. This takes AGES! I am thinking that there should a much less intense way of doing this - maybe a filtering option?
Your thoughts please...many thanks.
I am having a process time issue. Basically I have a summary table that reads from the lines of various other worksheets. Many of these will be blank - but the number of blank lines will change and so I have the following code in the worksheet:
Code:
Private Sub Worksheet_Activate()
Dim x As Integer
x = 2
Do Until x = 190
If Cells(x, 5) = 0 Then
Rows(x).EntireRow.Hidden = True
Else
Rows(x).EntireRow.Hidden = False
End If
x = x + 1
Loop
End Sub
This just cycles through the 189 row, checking if the total is zero and hiding the row if it is, unhiding it if it isn't. This takes AGES! I am thinking that there should a much less intense way of doing this - maybe a filtering option?
Your thoughts please...many thanks.