[µo°Ý] °õ¦æ¿ù»~¶¥¬q13-«¬ºA¤£²Å¦X

rouber590324

DEAR ALL ¤j¤j
²³æ¤§µ{¦¡¦p¤U
If Sheet48.Cells(M, 16) = Sheet10.Range("G168") And (Sheet48.Cells(M, 10) - Sheet10.Range("B84") = 0) Then
¥X²{
°õ¦æ¿ù»~¶¥¬q13-«¬ºA¤£²Å¦X
?????
¦³­þ¦ì¤j¤jª¾¹D­ì¦]¬°¦ó???

rouber590324

µ{¦¡¦p¤U
Sub PCBCTREADGats7ALL§÷½sÂà¸mA()
Sheet48.Visible = True
Sheet49.Visible = True
Sheet49.[A2:E65536].ClearContents
X = Sheet48.[G65536].End(xlUp).Row
Y = Sheet49.[A65536].End(xlUp).Row + 1
For M = 2 To X
If Sheet48.Cells(M, 10) - Sheet10.Range("B84") = 0 And Sheet48.Cells(M, 11) - Sheet10.Range("B85") < 0 And Sheet48.Cells(M, 12) - Sheet10.Range("B85") >= 0 And Sheet48.Cells(M, 13) - Sheet10.Range("B86") = 0 And Sheet48.Cells(M, 14) - Sheet10.Range("B87") < 0 And Sheet48.Cells(M, 15) - Sheet10.Range("B87") >= 0 Then
Sheet49.Cells(Y, 1) = Sheet48.Cells(M, 7)
Sheet49.Cells(Y, 2) = Sheet48.Cells(M, 8)
Sheet49.Cells(Y, 3) = Sheet48.Cells(M, 1)
Sheet49.Cells(Y, 4) = Sheet48.Cells(M, 2)
Sheet49.Cells(Y, 5) = Sheet48.Cells(M, 3)
Y = Y + 1
End If
Next
End Sub

stillfish00

¦^´_ 1# rouber590324
µo¥Í¿ù»~®É°»¿ù
¬ÝM­È¬O¦h¤Ö?
¬Ý¸ÓM­È¤U¡A³o´X­ÓÀx¦s®æªº¤º®e¤À§O¬O¤°»ò?

rouber590324

·PÁ  stillfish00 ¤j¤j
1.ÁA¸Ñ.¥Î±z¤§¤è¦¡¤w§ä¥X°ÝÃDÂI
   THANKS*10000