Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The If is simple:
Sub stephen() For i = 31 To 1000 If Cells(i, "U").Value = 0 And Cells(i, "V").Value = 0 Then Cells(i, "U").EntireRow.Hidden = True End If Next End Sub -- Gary''s Student - gsnu200761 "Stephen" wrote: 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. |
Reply |
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) |