Hide row based on cell value

[lapta301]

Dear All

I know that there are many requests for this but nothing seems to cover my need.

I would like to select a range of rows and hide only those that contain a % character with a space either side within the text in column A. It would also be helpful if the reverse could be available to only show those that do not contain a % character.

As ever all help is most appreciated.

 

[mkaniewski]

Hello,

I would apply a filter to the entire column or at least to a part of a column, You want to analyze. Then apply a filter called "contains..." and as a character fill "%". I tried this and the result was that all cells with "%" character in any combinations have been shown.

I hope this helps

 

[SteveO59L]

Something along the lines of

Dim c As Range, rng

Dim LASTROW As Long

LASTROW = Cells(Rows.Count, 1).End(xlUp).Row

Set rng = Range("a1:a" & LASTROW)
For Each c In rng
If InStr(c, " % ") Then
c.EntireRow.Hidden = True
End If
Next c

 

[lapta301]

mkaniewski

Thank you for your response.

I did try that but my problem is that it is not for a complete column just specific ranges and the top few rows are blank in columns A-C.

 

[lapta301]

Steve

Thank you for your response which works fine but as I have reason to only do this over differing ranges could it be adjusted to work on a range that is selected by me rather than the whole column.

Assuming that this can be done. could you also please add a version that opens up any hidden rows within the range and then shows only the rows that do have the % sign in column A.

I hope that this makes sense and again my thanks for taking the time with my problem