Suggestion
by mr.sweetchuck
In reply to
hide rows with specific v ...
Hi,
Not sure which PL that is but, why not try finding rows with a value of less than (<
0.01 or 0.1%, whichever is more appropriate.
chuck
hide rows with specific value
here is the code i am using:
Dim ZoekIn As Range, Vind As Range
Dim Celtel As Range
With ActiveSheet.Columns(7)
Set ZoekIn = .Find("0.0%")
If Celtel Is Nothing Then
Set Celtel = ZoekIn
End If
If Not ZoekIn Is Nothing Then
Set Vind = ZoekIn
Do
Set Celtel = Union(Celtel, ZoekIn)
Set ZoekIn = .FindNext(ZoekIn)
Loop While Not ZoekIn Is Nothing And ZoekIn.Address <> Vind.Address
End If
End With
Celtel.EntireRow.Hidden = True
This conversation is currently closed to new comments.