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

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.

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

Not sure if it is the best method but I usually test for zero or blanks this
way.

Sub Test_4_Zero()
If Range("E3") = 0 And Len(Trim(Range("E3"))) 0 Then
MsgBox "Range E3 = zero and not blank"
Else
MsgBox "Range E3 is blank"
End If
End Sub

Regards,

OssieMac

" wrote:

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.