I'm trying to loop throw rows and say "if the cell in this column begins with 49, hide the entire row". Here's my code:
For i = 2 To LastRow
If Rows("AK" & i).Value Like "49*" Then
Rows("AK" & i).EntireRow.Hidden = True
Next i
It keeps stopping on the last line and saying "For without next". Can it not see the FOR line three lines up? This is just one of many stat开发者_如何学运维ements I have like this but I think fixing this one will help me format the others. What am I doing wrong?
Your missing an End If
(The wording is like that because It sees a Next
within an If
block without a matching For
; which is illegal)
For i = 2 To LastRow
If Range("AK" & i).Value Like "49*" Then
Range("AK" & i).EntireRow.Hidden = True
End If
Next i
End if is missing !
It is required if you put the next instruction on another line.
精彩评论