Can you hide an blank if statement?

[zilch4ry]

hi everyone,

right, i have created a pizza order spreadsheet for an ict project and as part of this i have a final order section which shows all of the selections made by the customer. What i really wanted to do was if the quantity of one of the pizzas was set to "1", i wanted only that pizza to be seen in the final order screen, however i couldn't see anyway of doing this. I finally decided to create an if statement which if the quantity was set to 1 then the name of the pizza being ordered would show up and if the quantity was 0 then the cell would be blank using "" as the false answer.

So i guess my question is, "can i hide an entire row if the quantity of a pizza is set to 0, resulting in only pizzas showing in the order table if it has 1 or higher in the quantity cell".

If anybody could explain a way of doing this, it will be hugely appreciated- even if it isn't possible i wouldn't mind knowing either.

thanks in advance,



Tom

 

[Michael M]

Hi Tom
Can't be done with a formula. To hide a row based on a condition, you would need to use VBA
Something like this, if any row in column "A" is equal to 0, then the row will be hidden.
Might be a starting point.

Sub remove()
Dim r As Long, LR As Long, stxt As String	
LR = Cells(Rows.Count, "A").End(xlUp).Row	
        For r = LR To 2 Step -1	
                If Range("A" & r).value = 0 Then	
                    Rows(r).EntireRow.Hidden = True	
                End If	
        Next r	
End Sub

 

[zilch4ry]

That worked great! Thank you, but what would i add to the end of the code you posted to make the cells re-appear if the quantity is higher than 0?

 

[zilch4ry]

don't worry I figured it out :P