View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
courtesio99[_7_] courtesio99[_7_] is offline
external usenet poster
 
Posts: 1
Default Meaning of simple code

Can I know wat does the following statement mean?

For i = 161 To 301
If Trim(Cells(i, 7)) = "1" Then
Rows(i).Hidden = True
ElseIf Trim(Cells(i, 7)) = "True" Then
Rows(i).Hidden = True
End If
If Trim(Cells(i, 7)) = "0" Then
Rows(i).Hidden = False
End If
Next i

Basically, I dunno the meaning of Trim(Cells(i,7))
Can someone pls explain

--
Message posted from http://www.ExcelForum.com