macro to hide row with 0.00
 

I have a financial spreadsheet with hyperlinks that I want to hide the row
when the result in column C is 0.00 and if the value is ever greater than
zero to display the row.

I tried one macro and it just hid a the blank rows.

Thanks

macro to hide row with 0.00
 

WhaT ROW or ROWS are you wanting to hide

"Lori" wrote:

I have a financial spreadsheet with hyperlinks that I want to hide the row
when the result in column C is 0.00 and if the value is ever greater than
zero to display the row.

I tried one macro and it just hid a the blank rows.

Thanks

macro to hide row with 0.00
 

The row that has a 0.00 displayed in column C and I would actually like to
hide the two rows above the row that has the results displayed as 0.00 also.
Does that make sense?

"Mike" wrote:

WhaT ROW or ROWS are you wanting to hide

"Lori" wrote:

I have a financial spreadsheet with hyperlinks that I want to hide the row
when the result in column C is 0.00 and if the value is ever greater than
zero to display the row.

I tried one macro and it just hid a the blank rows.

Thanks