Question
-
Topic
-
hide rows with specific value
LockedHi , i am trying to hide rows in my worksheet that hav 0% in a certain column , problem is that i need 2 decimal places and if i have 20.0% then it hides that row as well.Please help !!
here is the code i am using:
Dim ZoekIn As Range, Vind As Range
Dim Celtel As RangeWith 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 WithCeltel.EntireRow.Hidden = True
All Answers
Viewing 1 reply thread