Pawel
07-27-2016, 04:48 AM
Hi,
I'm trying to create macro that hides rows if cell contains certain word.
The problem is that macro should only hide those rows that contain this cell.
As for now I have sth like this but it's not working:
Dim rng As Range
Set rng = Range("B1:B100")
For Each Cell In rng
If InStr(1, rng, "low") Then Cells(rng).EntireRow.Hidden = True
Next Cell
Please help.
I'm trying to create macro that hides rows if cell contains certain word.
The problem is that macro should only hide those rows that contain this cell.
As for now I have sth like this but it's not working:
Dim rng As Range
Set rng = Range("B1:B100")
For Each Cell In rng
If InStr(1, rng, "low") Then Cells(rng).EntireRow.Hidden = True
Next Cell
Please help.