Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
if not both zero then show the row.
If you wish to show them also, perhaps: Sub Demo() Dim Rng As Range For Each Rng In [U31:U1000].Cells Rng.EntireRow.Hidden = Rng = 0 And Rng(1, 2) = 0 Next Rng End Sub -- Dana DeLouis "Stephen" wrote in message ... I'm trying to say from rows 31 thru 1000, if U and V are zero then hide the row. if not both zero then show the row. Having problems putting this into an if statment wondering if I'd be better served using a case statement but not sure how to write it. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
countif function: how to distinguish case/make case sensitive | Excel Worksheet Functions | |||
change data of entire column from small case to upper case | Excel Worksheet Functions | |||
Changing multiple cell text from lower case to upper case | Excel Discussion (Misc queries) | |||
excel'03 how to convert a column from upper case to proper case | Excel Discussion (Misc queries) | |||
Change the text from lower case to upper case in an Excel work boo | Excel Discussion (Misc queries) |