ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] «ü©w½d³ò¨Ì¾Ú¯S©w¤å¦r "N" ¯à¦Û°ÊÁôÂæC¡K

For i = 2 To 1000
    With Sheet33
    If Trim(.Cells(i, 5)) = "N" Then
    .Rows(i).Hidden = True
    Else
    .Rows(i).Hidden = False
    End If
    End With
    Next
ù

TOP

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD