Hiding entire rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a construction contents list, with this list I can order various
items. the rows are quantity - code - description - list - total

what I need to do is to press a command button and hide the rows where the
quantity (column A) = "".
I've tried a number of the examples in the answers already but no joy.
Can anyone help me please.

Thank you all
 
I have a construction contents list, with this list I can order various
items. the rows are quantity - code - description - list - total

what I need to do is to press a command button and hide the rows where the
quantity (column A) = "".
I've tried a number of the examples in the answers already but no joy.
Click to expand...

Something like this maybe?

Dim R As Range
For Each R In Range("A1:A501")
If R.Value = "" Then Rows(R.Row).Hidden = True
Next

Change the Range as required.

Rick
 
Back
Top