Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Or Like
In Excel2000, I have the following code:
For Each cll In Range("b8:b380") ' Rows to Hide take out Others if Others is to be shown If cll Like "Comp $ Program*" Or cll Like "FC Program*" _ Or cll Like "Ship*" _ Or cll Like "Duty*" Or cll Like "Others*" _ Or cll Like "COS*" Or cll Like "LC" _ Or cll Like "Mark*" Or cll Like "Check*" _ Then cll.Select Selection.EntireRow.Hidden = True End If Next Actually, I have many more "Or cll Like" lines that I edited out. Is there another way to code this than using so many multiple Or's? Thanks |