ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hiding Rows in EXCEL (Conditionally) (https://www.excelbanter.com/excel-programming/276972-re-hiding-rows-excel-conditionally.html)

Paul B[_6_]

Hiding Rows in EXCEL (Conditionally)
 
Darran, have a look at data filter auto filter and custom ,is less than or
equal to 0

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
"Darran Caputo" wrote in message
om...
Is there a way to hide rows in a worksheet based on a value in the row?

In other words:


IF A1 0 then "Hide Row"





All times are GMT +1. The time now is 11:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com