Hiding rows based on a cell?

  • Thread starter Thread starter OX_Gambit
  • Start date Start date
O

OX_Gambit

Is there a way that I can hide a row based on a cells value? Or do I have to
run a macro to do so?

I will be positng this in the Programming section as well.
 
To truly hide, you would need a macro
However, you could make it look blank using conditional formatting making
the font colour match the worksheet background colour (generally white)
best wishes
 
Say we want to hide all rows in which column A contains "XXX":

Sub hideum()
Dim i As Long
n = Cells(Rows.Count, "A").End(xlUp).Row
For i = 1 To n
If Cells(i, 1).Value = "XXX" Then
Rows(i).Hidden = True
End If
Next
End Sub
 
sorry for tagging on to this old post but its very similar to a question i
have. but for starters, i simply copy/pasted the below macro on the "view
code".
i typed in various values down column A, including a couple of examples of
xxx.
anything else i can try? for proper protocol shoud i write a new request?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide columns based on row values 2
Creating a function to auto hide rows 1
Hiding/Exposing Rows based on a cell value 10
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
hide row based on cell value 2
Is there a way to conditionally hide rows in Excel? 1
Is there a formula to hide/ display row based on cell value in Exc 2
Hide unused rows based on column info 5

Back
Top