Hiding all rows where the cell value in column 13 of same row = $0.00

L

lehr.craig

For example if the result of the formula in e13 is $0.00, then row 13
hides when macro is executed. I do not, however, want the row to hide
just because e13 is empty.

If it matters, the formula in e13 is =c13*d13 where c13 is the number
of shares owned and d13 is the price of each share. e13 gives the
value of the shares. If the value is $0.00, then I want the row to
hide. Again, if a cell in column 13 is empty, I don't want that row to
hide

Thanks in advance for any help I can get.
 
B

Barb Reinhardt

How about

If Not IsEmpty(Range("E13")) And Range("E13").Value = 0 Then
Range("E13").EntireRow.Hidden
End If

HTH,
Barb Reinhardt
 

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

Macro to autofill formula in every row 1
Copy addition formula of non-consecutive horizontal cells 2
Drop down list control value in vba 2
sum every nth cell in a row 1
#DIV/0! Error......why is it ignoring the ' Otherwise "" ' ? 3
Macro: If(And(... 4
Autonumber field in Excel that behaves the same as Access 0
Skip copying empty column where remaining rows are filled 2

Top