Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding all rows where the cell value in column 13 of same row = $0
How about
If Not IsEmpty(Range("E13")) And Range("E13").Value = 0 Then Range("E13").EntireRow.Hidden End If HTH, Barb Reinhardt " 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding column if cell in previous column is empty-revised | Excel Programming | |||
Hiding rows containing zero in certain column on multiple sheets | Excel Programming | |||
Hiding rows based on a column value | Excel Programming | |||
Hiding Rows when a cell = 0 | Excel Discussion (Misc queries) | |||
Hiding Rows in a Range based on column A value | Excel Programming |