| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hide/unhide macro | Excel Discussion (Misc queries) | |||
| macro to hide columns | Excel Worksheet Functions | |||
| Excel Macro Hide | Excel Worksheet Functions | |||
| Help with a hide row macro (not using filter) | Excel Worksheet Functions | |||
| macro to hide rows | Excel Discussion (Misc queries) | |||
Hybrid Mode
